Sql limit to 5 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

Similar codes

3 votes315 views3 answers
Print in pl sql
SQL
0 vote389 views1 answer
New rails app with mysql
SQL
2 votes336 views1 answer
Oracle sql day of month from date
SQL
9 votes351 views6 answers
Replace sql
SQL
27 votes350 views6 answers
Set password mysql
SQL
1 vote344 views1 answer
Oracle repeat_interval 5 minutes
SQL
2 votes331 views2 answers
Mysql date range
SQL
1 vote373 views1 answer
Login to database mysql terminal
SQL
1 vote342 views1 answer
Use of now() in mysql
SQL
1 vote327 views1 answer
Median mysql
SQL