SQL TOP clause

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

---