Sql limit order by

-- 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 order by

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

Source: techonthenet.com

Similar codes

0 vote260 views1 answer
TSQL Find csv file in folder
SQL
0 vote239 views1 answer
Distance calculator from lat long sql query
SQL
1 vote191 views1 answer
Oracle user last connected
SQL
0 vote203 views1 answer
Como saber si tengo mysql instalado
SQL
3 votes217 views3 answers
Mysql declare variable
SQL
0 vote208 views1 answer
Psql get table data types
SQL
6 votes199 views2 answers
Insert into select mysql
SQL
4 votes184 views1 answer
Oracle show error line number
SQL
2 votes243 views1 answer
Oracle find constraints referencing a table
SQL
0 vote205 views2 answers
Sql 2 way of select unique
SQL