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 votes113 views1 answer
Oracle asynchronous query
SQL
1 vote122 views1 answer
How to between in sql
SQL
0 vote110 views1 answer
Postgres regex word boundary
SQL
0 vote130 views1 answer
Insert using condition postgres
SQL
0 vote157 views1 answer
Scheduled mysql database backup in linux
SQL
0 vote131 views1 answer
Select new table sql
SQL
1 vote119 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote126 views1 answer
How to add timestamp column in mysql
SQL
-1 vote113 views1 answer
Round up and down sql
SQL
0 vote122 views10 answers
John the ripper mysql
SQL