/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

1 vote322 views1 answer
Sql not equal multiple columns
SQL
0 vote330 views1 answer
Postgresql show owner of database
SQL
4 votes328 views1 answer
For loop postgresql
SQL
0 vote336 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote326 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote383 views1 answer
Python get backup of sql
SQL
2 votes317 views2 answers
How to DROP a table in mysql
SQL
0 vote272 views1 answer
Query for maximum salary
SQL
9 votes331 views3 answers
Mysql show table column full description
SQL
1 vote319 views1 answer
Mysql return text after a final full stop
SQL