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 vote179 views1 answer
Sqldf change user
SQL
0 vote194 views1 answer
Sql find record cannot cast date
SQL
0 vote188 views1 answer
H2 auto increment and unique
SQL
0 vote264 views1 answer
How to add auto increment primary key
SQL
0 vote181 views1 answer
Create table sql generator
SQL
5 votes144 views1 answer
Postgres upsert
SQL
0 vote175 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote200 views1 answer
Sql examples from framework
SQL
0 vote181 views2 answers
How to tun mysql on ubunto
SQL
20 votes181 views5 answers
Sql show tables
SQL