how to select first N rows from a table in T-SQL?

Viewed 140921

Is there any way to select, for example, first 10 rows of a table in T-SQL (working MSSQL)?
I think I saw something in Oracle defined as rownum meta variable, used in a following way

select * from Users where rownum<=10
But what about MSSQL?

7 Answers
Related