/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

2 votes184 views1 answer
Mysql auto increment jumping
SQL
6 votes315 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
1 vote215 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
1 vote209 views1 answer
Altrer name column postgres
SQL
0 vote235 views1 answer
Local pg_sql to heroku pg_sql
SQL
20 votes216 views4 answers
Sql count if
SQL
3 votes201 views1 answer
Mysql set field unique
SQL
0 vote216 views1 answer
Sql express database size limit
SQL
4 votes203 views1 answer
Mysql biginteger size
SQL
35 votes236 views5 answers
Sql alter column
SQL