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

No comments: