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

3 votes118 views3 answers
Restart mysql mac
SQL
4 votes105 views2 answers
Oracle drop job
SQL
2 votes111 views2 answers
Create empty table from existing table
SQL
8 votes120 views4 answers
Convert date to dd/mm/yyyy sql
SQL
1 vote290 views1 answer
Postgres upgrade to superuser
SQL
0 vote113 views1 answer
Dynamic where clause in sql server stored procedure
SQL
2 votes130 views1 answer
Mysql now format
SQL
1 vote102 views1 answer
Sql bitwise operators
SQL
15 votes99 views2 answers
Install mysql 8 ubuntu 18.04
SQL
1 vote100 views1 answer
Ilike for date postgres
SQL