/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 votes193 views1 answer
Oracle select first 10 rows
SQL
1 vote188 views1 answer
Right outer vs left outer join
SQL
0 vote186 views1 answer
Postgresql alter column nullable
SQL
3 votes247 views1 answer
Sql several or
SQL
2 votes296 views1 answer
How to select from mssql
SQL
0 vote173 views0 answer
SQL
0 vote195 views1 answer
Google sheets filter rows above current cell
SQL
0 vote255 views1 answer
Oracle sqlp update amount / quantity
SQL
2 votes194 views1 answer
Find all triggers in database
SQL
0 vote207 views1 answer
Helptext in sql
SQL