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 vote238 views1 answer
Oracle show running job
SQL
0 vote257 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote238 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote234 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote264 views2 answers
Oracle chain rules
SQL
0 vote266 views1 answer
Mysql get first 2 characters of string
SQL
7 votes244 views6 answers
Nth highest salary in sql
SQL
11 votes256 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote229 views1 answer
Uuid sqlalcomany
SQL
1 vote238 views1 answer
Increasing font and zooming in mysql workbench
SQL