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 votes348 views1 answer
Oracle sysdate - 1 month
SQL
0 vote376 views2 answers
Sql unique
SQL
0 vote331 views1 answer
Select all tables linked server sql
SQL
10 votes341 views5 answers
Between keyword in sql
SQL
0 vote342 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote360 views1 answer
Mssql disable foreign key constraint
SQL
-1 vote329 views1 answer
Ssql to lowercqse
SQL
1 vote377 views2 answers
Mysql add column tinyint default 0
SQL
8 votes332 views3 answers
Alter table auto_increment
SQL
5 votes333 views1 answer
Alter table add comment oracle
SQL