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

2 votes152 views3 answers
Current month mysql query
SQL
0 vote148 views1 answer
Sql sum if
SQL
0 vote151 views1 answer
Create a PostgreSQL user django on mac
SQL
15 votes155 views2 answers
Open postgress in terminal mac
SQL
3 votes105 views1 answer
If 0 return null else return query mysql
SQL
0 vote196 views1 answer
Mysql show schema
SQL
21 votes146 views3 answers
Sql average
SQL
5 votes155 views2 answers
Sql server check port number
SQL
0 vote150 views1 answer
Find and replace query in wordpress\
SQL
0 vote146 views1 answer
Sql datediff db2
SQL