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

9 votes177 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote180 views1 answer
How to change mysql port in xampp
SQL
0 vote176 views1 answer
Postpresql relation not found
SQL
0 vote195 views1 answer
Java nosql sort
SQL
2 votes162 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
4 votes177 views2 answers
Mysql show indexes on table
SQL
1 vote184 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
2 votes182 views1 answer
Mysql shell insert into
SQL
0 vote163 views1 answer
Bigquery declare
SQL
1 vote171 views1 answer
Oracle datafile max size 32gb
SQL