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

0 vote248 views1 answer
Drop check command
SQL
7 votes270 views2 answers
Oracle foreign key reference table
SQL
0 vote267 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote313 views1 answer
Sql values that contains certain multiple ids
SQL
1 vote257 views1 answer
How to check the mysql version mac
SQL
1 vote263 views1 answer
Drop table if exists oracle
SQL
11 votes278 views2 answers
How to import mysql database command line
SQL
2 votes282 views1 answer
Mysql shell insert into
SQL
0 vote256 views2 answers
Sql server select first day of previous year
SQL
1 vote281 views2 answers
Get table column names sql laravel
SQL