SQL SELECT TOP

The SELECT TOP statement is used to retrieve the top specified number of rows from a table.

Syntax:

SELECT TOP n * FROM tableName

Where n is the number of rows.

Example:

SELECT TOP 2 * FROM EMPLOYEE;

Output:

EMP_ID EMP_NAME AGE SALARY 1 Parbhjot 28 35000 5 Parmender 28 45000