Home > DeveloperSection > Interviews > What does TOP Operator Do in SQL?

Posted on    August-21-2014 12:06 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  878  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Posted on    August-21-2014 12:00 AM

The TOP operator is used to specify the number of rows to be returned by a query. The TOP operator has new addition in SQL SERVER 2008 that it accepts variables as well as literal values and can be used with INSERT, UPDATE, and DELETES statements.

Don't want to miss updates? Please click the below button!

Follow MindStick