Query Limits, and Distinct and Ordered Data

In addition to filtering, we can further customize our SELECT statements by using TOP, DISTINCT, and ORDER BY keywords.

Return fixed amount of rows

By default, a SELECT statement returns all rows from the table. If we add filtering options, the statement returns all rows that satisfy the criteria. We can change this behavior by limiting the number of rows returned:

SELECT TOP [MaxNumberOfReturnedRows] * FROM TableSchema.TableName;

With the TOP ...