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

1 vote177 views2 answers
End mysql command
SQL
0 vote166 views1 answer
Mysql range of dates overlap
SQL
7 votes191 views4 answers
Mysql delete older duplicates
SQL
0 vote164 views1 answer
Ms sql filter all sympbol
SQL
2 votes171 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote176 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
5 votes150 views5 answers
Sqlite install python
SQL
2 votes146 views1 answer
Mysql sysdate
SQL
25 votes153 views3 answers
How to use a database to see tables mysql
SQL
0 vote154 views2 answers
Default constraint in ms sql
SQL