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 vote361 views1 answer
How to access to mysql without root
SQL
1 vote337 views1 answer
How to select department from table
SQL
0 vote370 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote340 views1 answer
Select from 3 tables one is empty
SQL
0 vote356 views1 answer
Mysql query problems and solutions
SQL
0 vote384 views1 answer
Get only one row in mysql
SQL
0 vote354 views1 answer
Update sqlite
SQL
0 vote385 views1 answer
Oracle grant create job
SQL
0 vote380 views1 answer
SQL Hello, [firstname] [lastname]
SQL
1 vote355 views1 answer
Duplicating a MySQL table with all the data Command
SQL