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 vote170 views1 answer
Sql select most frequent value in group
SQL
4 votes167 views2 answers
How to count items with same name in sql
SQL
4 votes193 views2 answers
Linq join
SQL
0 vote173 views1 answer
Mysql cdn link
SQL
0 vote181 views1 answer
Sql query interview questions githu
SQL
2 votes179 views4 answers
Mysql select into new table
SQL
0 vote172 views2 answers
Sql query unique
SQL
32 votes182 views6 answers
Sql count where
SQL
0 vote189 views1 answer
Str_to_date sql server
SQL
0 vote177 views2 answers
Insert into
SQL