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 vote180 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
1 vote144 views1 answer
Mysql alter decimal precision
SQL
0 vote173 views1 answer
Mysql trigger to delete old data
SQL
1 vote169 views2 answers
Mysql add column tinyint default 0
SQL
4 votes191 views1 answer
Postgresql list sequences
SQL
5 votes154 views1 answer
Get column name sql server
SQL
0 vote163 views1 answer
Replace \n sql
SQL
1 vote139 views1 answer
Oracle start job
SQL
0 vote140 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote145 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL