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

5 votes246 views1 answer
Oracle get ddl
SQL
0 vote208 views2 answers
Mysql slave status
SQL
1 vote201 views1 answer
Mysql average of multiple columns
SQL
3 votes228 views1 answer
Locate sql server
SQL
1 vote219 views1 answer
Sql order by timestamp
SQL
51 votes346 views6 answers
Opera gx
SQL
0 vote220 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote218 views1 answer
Alter rename command in mysql
SQL
0 vote221 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote215 views1 answer
SQL Server Altering Column to be Unique
SQL