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.
