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

1 vote137 views1 answer
Cross schema query oracle 2 users
SQL
0 vote125 views1 answer
Call procedure in wordpress
SQL
21 votes136 views1 answer
SQL cheat sheet pdf
SQL
0 vote139 views1 answer
Mysql drop trigger
SQL
0 vote169 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote149 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote151 views1 answer
Mariadb create index if not exists
SQL
0 vote148 views1 answer
Mssql disable foreign key constraint
SQL
44 votes217 views6 answers
Rename command in sql
SQL
11 votes142 views2 answers
Having in sql
SQL