SQL TOP - Introduction and syntax

Explain the SQL TOP statement. Write SQL syntax for the SQL TOP statement along with an example.

TOP clause is used to specify the number of records to return. Usually used for large tables.

Syntax:
SELECT TOP number|percent column_name(s) FROM table_name

Example:
SELECT TOP 2 * from employee