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

16 votes167 views2 answers
Mysql date between two dates
SQL
0 vote127 views1 answer
Procedures and functions in pl/sql
SQL
13 votes163 views4 answers
Mysql get last row
SQL
0 vote188 views1 answer
Nuget sqllite-net-pcl
SQL
5 votes159 views1 answer
How to check nls timestamp format in oracle
SQL
0 vote170 views1 answer
Recursive query herarchical data sql server
SQL
0 vote174 views1 answer
Mysql average from two table
SQL
0 vote173 views1 answer
Insert array into mysql column
SQL
0 vote159 views1 answer
Export partttion and import in oracle
SQL
0 vote172 views1 answer
Mysql add root password
SQL