/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 vote218 views1 answer
Sqlalchemy empty table
SQL
0 vote196 views1 answer
Sql change default collation to utf8
SQL
0 vote203 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote207 views1 answer
Delete first row in sql
SQL
8 votes223 views2 answers
Mysql grant all privileges to user from any host
SQL
1 vote225 views1 answer
Store select query result in variable sql server
SQL
0 vote206 views1 answer
Tsql pad left
SQL
1 vote206 views1 answer
How to delete a record from sqlite in android
SQL
2 votes202 views1 answer
Set boolean flasksql
SQL
13 votes190 views3 answers
Uninstall mysql centos 7
SQL