/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

4 votes263 views3 answers
Is not null sql
SQL
4 votes260 views2 answers
Tsql utf to local time
SQL
0 vote248 views1 answer
Sql query interview questions githu
SQL
0 vote263 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote270 views1 answer
C# get sql min date
SQL
1 vote272 views2 answers
Procedure syntax
SQL
0 vote245 views1 answer
Data types mysql vs postgresql
SQL
0 vote269 views3 answers
How to run sql query
SQL
19 votes275 views3 answers
How to change column type psql
SQL
0 vote261 views1 answer
Oracle sql log to console
SQL