/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 vote145 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
1 vote131 views1 answer
Mysql select another database
SQL
6 votes145 views2 answers
Postgresql restore from dump
SQL
0 vote105 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote147 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote150 views2 answers
Coursera spark sql max count
SQL
7 votes177 views1 answer
Show line number in sql server
SQL
0 vote146 views1 answer
Oracle merge insert if not exists
SQL
0 vote142 views1 answer
Oracle current session details
SQL
0 vote141 views2 answers
How to check if sqlite table exists in nodejs
SQL