/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 vote151 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote185 views1 answer
Mysql root localhost run
SQL
1 vote179 views1 answer
Sql server cast date dd/mm/yyyy
SQL
3 votes131 views1 answer
System.debug apex
SQL
2 votes166 views1 answer
Oracle apex list connected users
SQL
2 votes219 views5 answers
Install postgresql 10 centos 7
SQL
0 vote177 views1 answer
Database get 10 user aleatory
SQL
0 vote196 views1 answer
How to change the field size of an existing column
SQL
5 votes231 views3 answers
Create function in postgresql
SQL
1 vote160 views1 answer
Media sql
SQL