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.
Liked By
Write Answer
What does TOP Operator Do in SQL?
Join MindStick Community
You have need login or register for voting of answers or question.
Sumit Kesarwani
21-Aug-2014The 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.