Sql limit results

-- MySql
SELECT * FROM emp ORDER BY sal DESC LIMIT 5;	
-- SQL Server 
SELECT TOP 5 * FROM emp ORDER BY sal DESC;	
-- Oracle < 11g 
SELECT * FROM ( SELECT * FROM emp ORDER BY sal DESC ) WHERE ROWNUM <= 5;
-- Oracle 12c +
SELECT * FROM emp ORDER BY sal DESC FETCH FIRST 5 ROWS ONLY;

Sql limit to 5 results

SELECT expressions
FROM tables
[WHERE conditions]
[ORDER BY expression [ ASC | DESC ]]
LIMIT number_rows [ OFFSET offset_value ];

Source: techonthenet.com

Sql limit results

LIMIT 5

Similar codes

13 votes253 views2 answers
Oracle inner join
SQL
1 vote274 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote245 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
3 votes285 views3 answers
Postgresql random number
SQL
0 vote278 views1 answer
Copy row from db to db mysql
SQL
15 votes252 views2 answers
Sql order by multiple columns
SQL
0 vote260 views1 answer
Get records in sql according to month name and count
SQL
8 votes278 views10 answers
Sql
SQL
0 vote271 views1 answer
How to to get time in sql
SQL
3 votes290 views2 answers
@sqlresultsetmapping
SQL