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 vote320 views1 answer
Sql server list locks
SQL
0 vote339 views1 answer
Select distinct after join
SQL
1 vote302 views2 answers
Drop table if exists test
SQL
0 vote318 views1 answer
Cross apply top for each row t1
SQL
0 vote292 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
4 votes307 views3 answers
NOT NULL SQL
SQL
1 vote332 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote298 views1 answer
Where case insensitive like mysql
SQL
1 vote318 views1 answer
How to start with sql
SQL
0 vote311 views1 answer
How to alter length character varying postgres
SQL