MSSQL syntax

[Anon]

Hey guys,

I would like to LIMIT the number of records being returned... What is the MSSQL equivilent of LIMIT?

Thanks,
-Travis

[btubalinal]

You can use TOP. Example:

SELECT TOP 5 * FROM table_name;

This will return the TOP n rows in the table, based on how it's stored in the table. If you want to select the TOP n rows depending on something, you could use whatever other legal clauses there are in SQL Server, including WHERE, ORDER BY, etc.

Bart