Limit Number Of Rows Returned In MS SQL

23rd September 2008

To limit the number of rows returned in a MS SQL query you need to use the TOP command. This goes before you name the columns that are to be returned by the SELECT statement.

The following query returns the first 35 rows from a table.

Add new comment

The content of this field is kept private and will not be shown publicly.