SQL SELECT TOP

by

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

 
Next Topic: SQL SELECT IN Operator with example.
Previous Topic: SQL DISTINCT keyword with example.