/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

0 vote135 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote127 views1 answer
How to get initials in sql
SQL
1 vote182 views1 answer
Psql client write to bash variable
SQL
-1 vote141 views1 answer
Window functions in sql
SQL
0 vote150 views1 answer
Oracle show grants on table
SQL
0 vote102 views2 answers
Spring properties file for db
SQL
0 vote137 views1 answer
Low level operator in dbms
SQL
5 votes143 views2 answers
Get number of columns sql
SQL
-1 vote152 views5 answers
Convert sql to linq query online
SQL
0 vote169 views1 answer
SQL Cut part string
SQL