/SQL/Fetch first 5 rows in oracle sql developer

Fetch first 5 rows in oracle sql developer

-- 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 vote211 views2 answers
Mysql dump structure only
SQL
0 vote286 views1 answer
SQL Server Enterprise
SQL
4 votes189 views1 answer
Force drop all tables postgres
SQL
1 vote280 views1 answer
Oracle transaction rollback not working
SQL
0 vote239 views1 answer
Mysql c commands
SQL
10 votes260 views6 answers
Mysql set root password
SQL
0 vote203 views1 answer
Insert into using contant values and source table columns with sql
SQL
9 votes214 views6 answers
Sql insert into
SQL
2 votes185 views1 answer
Postgresql left join distinct on
SQL
0 vote185 views1 answer
Change data type in mysql
SQL