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
One reply on “Select Top in SQL”
SQL Tutorial | Learn SQL 2022 - Scaz October 22, 2022 at 5:39 pm
[…] SQL SELECT TOP […]