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

0 vote173 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote174 views1 answer
Default value false mysql
SQL
1 vote356 views1 answer
Postgres upgrade to superuser
SQL
2 votes156 views1 answer
Oracle cpu per session
SQL
0 vote184 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
0 vote175 views1 answer
Postgresql auto increment not working
SQL
0 vote173 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
34 votes206 views6 answers
Install mysql client ubuntu
SQL
2 votes262 views1 answer
Oracle run_duration to number
SQL
-1 vote144 views1 answer
Mysql if example
SQL