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 votes116 views1 answer
Select database in sql
SQL
0 vote98 views1 answer
SQL Server format datetime
SQL
0 vote116 views1 answer
Postgress append string in select
SQL
3 votes108 views1 answer
Insert into table from another table mysql
SQL
0 vote111 views1 answer
Add alternate add column sql
SQL
1 vote105 views1 answer
Drop df constraint sql server
SQL
0 vote110 views1 answer
How to remove default in mysql
SQL
2 votes146 views2 answers
Postgres change owner of schema
SQL
0 vote133 views1 answer
Sql developer format sql
SQL
5 votes106 views2 answers
Update all rows mysql
SQL