SQL Server : SELECT TOP Statement

The SELECT TOP Query is basically used to select the required number of records.

Syntax:

SELECT TOP number FROM table_name;

As shown above, SELECT QUERY returned 3 records, as we have written 3 against TOP keyword.

It basically Limits the number of records that needs to be returned from a table or query resultset.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.