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 vote169 views1 answer
Sql composite key
SQL
0 vote180 views3 answers
Mysql regex replace
SQL
0 vote170 views1 answer
Sql remove decimal places
SQL
0 vote168 views2 answers
Null value in column violates not-null constraint
SQL
0 vote174 views1 answer
Mysql check datetime equals date
SQL
13 votes178 views2 answers
Sql count distinct group by
SQL
0 vote352 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote188 views1 answer
Query for backup a database at another location in file system
SQL
1 vote177 views2 answers
Mysql: command not found
SQL
12 votes167 views1 answer
Psql drop column
SQL