TOP N.md

TOP N

TOP

• Top 3 highest salary.

SELECT 
TOP 3 *
FROM Employee
ORDER BY Salary DESC

• Top 3 lowest salary

SELECT 
TOP 3 *
FROM Employee
ORDER BY Salary

LIMIT

SELECT *
FROM Employee
ORDER BY Salary DESC
LIMIT 3

FETCH FIRST N ROWS ONLY

• Used in standard SQL.

SELECT 
*
FROM Employee
ORDER BY Salary DESC
FETCH FIRST 10 ROWS ONLY