/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 vote266 views1 answer
Php delete database
SQL
-1 vote298 views4 answers
Sql view postgresql
SQL
0 vote286 views1 answer
Postegresql update to null
SQL
0 vote297 views1 answer
Command line mysql xampp
SQL
4 votes281 views1 answer
Conda install sqlalchemy
SQL
1 vote295 views1 answer
Select users with same username
SQL
0 vote284 views1 answer
Close sql query vb.net
SQL
0 vote280 views1 answer
Import sql in postgresql
SQL
0 vote256 views1 answer
Trim sql oracle
SQL
0 vote293 views5 answers
How to make trigger in phpmyadmin
SQL