/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 vote125 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
1 vote137 views1 answer
Sqlalchemy order by descending
SQL
0 vote130 views1 answer
Sql get count without group by
SQL
1 vote141 views1 answer
Round one decimal place mysql
SQL
0 vote187 views1 answer
Drop view sql
SQL
0 vote152 views1 answer
Dual in db2
SQL
5 votes186 views1 answer
Dbms_metadata.get_ddl table
SQL
1 vote138 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote131 views1 answer
Mysql begin statement
SQL
15 votes130 views5 answers
If null mysql
SQL