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 vote247 views1 answer
Set default value now() date
SQL
0 vote262 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote226 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote266 views1 answer
Sqlalchemy orm duplicate
SQL
18 votes231 views4 answers
Foreign key mySql
SQL
3 votes256 views1 answer
Mysql replace string in table
SQL
0 vote306 views1 answer
Sql query to select even numbers
SQL
3 votes270 views2 answers
To_char sql
SQL
3 votes251 views4 answers
Order by desc postgres
SQL
1 vote231 views3 answers
String to int mysql
SQL