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 vote264 views1 answer
T sql return on letters only
SQL
0 vote296 views1 answer
Function plsql
SQL
16 votes298 views4 answers
Ascending order mysql
SQL
0 vote350 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote301 views1 answer
Oracle date winter time
SQL
4 votes273 views1 answer
Mysql insert from local csv
SQL
0 vote321 views2 answers
Coursera spark sql max count
SQL
1 vote282 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote284 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote337 views1 answer
Mysql get nth highest
SQL