SQL Server : SELECT TOP Statement
The SELECT TOP Query is basically used to select the required number of records.
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.