TOP

The SQL SELECT TOP statement is used to retrieve records from one or more tables in a database and limit the number of records returned based on a fixed value or percentage.

Syntax For SQL:

SELECT TOP 5 Salary FROM employee

Syntax For MySQL:

SELECT * FROM Employee LIMIT 5

Syntax For Oracle:

SELECT * FROM Employee WHERE ROWNUM <= 5