Sql limit results returned

-- 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;

Similar codes

10 votes143 views6 answers
Mysql set root password
SQL
8 votes131 views10 answers
Sql
SQL
0 vote114 views1 answer
Mysql grouping functions
SQL
0 vote115 views1 answer
Sql grant select only
SQL
0 vote117 views1 answer
Create query in where clasue
SQL
0 vote125 views1 answer
Sql multiple into
SQL
0 vote144 views1 answer
Psql check table fields
SQL
0 vote108 views1 answer
Mysql cdn link
SQL
0 vote108 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
1 vote170 views1 answer
Mysql get max value and id
SQL