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 vote404 views1 answer
Pgadmin save data greyed out
SQL
3 votes357 views2 answers
Truncate all tables
SQL
0 vote370 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote352 views2 answers
Mysql add days to date
SQL
5 votes368 views6 answers
Sql foreign key
SQL
3 votes328 views1 answer
If 0 return null else return query mysql
SQL
1 vote376 views1 answer
ORA-01950
SQL
0 vote406 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote353 views1 answer
Query to get all primary keys and foreign key
SQL
23 votes354 views4 answers
How to uninstall postgresql in ubuntu
SQL