Explain the TOP clause in SQL Server.

The TOP clause is used to display the number of records to return. This clause is useful to return records from large tables.

Ex :

Select Top 5 * from Employees

This Query will display the only the first five records from the Employees.

Ex :

Select Top 25 percent * from Employees

This Query will display the 25% of the records from the table.