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 vote193 views2 answers
Postgresql variable in query
SQL
0 vote222 views1 answer
Sp help text in postgresql
SQL
0 vote176 views1 answer
Sql compound operators
SQL
1 vote133 views1 answer
Full text index mysql
SQL
3 votes185 views5 answers
Mysql get last inserted id
SQL
0 vote214 views2 answers
What is rownum in oracle
SQL
0 vote194 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote190 views1 answer
Closure in sql
SQL
0 vote164 views1 answer
Dnsmasq.conf location macos
SQL
0 vote201 views1 answer
Sql new line output
SQL