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 vote332 views1 answer
Current month transactions in mysql
SQL
0 vote255 views1 answer
Equi joins in oracle
SQL
2 votes258 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote260 views1 answer
Insert output identity
SQL
38 votes329 views6 answers
Ubuntu install mysql client
SQL
9 votes247 views2 answers
Get first 3 letters in sql
SQL
1 vote262 views1 answer
Launch sql script from docker in mysql
SQL
0 vote267 views2 answers
Nodejs mysql convert to plain object
SQL
0 vote244 views2 answers
Plan d'exécution requete oracle autotracer
SQL
1 vote268 views1 answer
Date_part mysql
SQL