/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 vote324 views1 answer
Oracle rolling back
SQL
0 vote330 views1 answer
Mysqldump ignore table
SQL
4 votes317 views1 answer
Check database name postgresql
SQL
0 vote364 views2 answers
Mysql missin expression near on
SQL
0 vote333 views2 answers
How to tun mysql on ubunto
SQL
0 vote348 views1 answer
Sql sum if
SQL
0 vote333 views1 answer
Pl/ sql change currency
SQL
0 vote339 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
24 votes334 views6 answers
Rename a column in sql server
SQL
0 vote418 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL