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

0 vote196 views1 answer
Group by max date
SQL
0 vote164 views1 answer
Stored procedures example
SQL
8 votes196 views2 answers
Select current_timestamp - interval '3 days';
SQL
0 vote163 views1 answer
Python sqlalchemy orm to select null values
SQL
1 vote198 views1 answer
Oracle user last connection date
SQL
0 vote370 views1 answer
Redirection 301 htaccess nom de domaine
SQL
3 votes168 views3 answers
Remove all spaces from string sql
SQL
0 vote168 views3 answers
Create and attach user to a postgresql database
SQL
4 votes169 views1 answer
Mysql ip address
SQL
-1 vote123 views1 answer
Oracle db list usernames
SQL