/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 vote327 views2 answers
Reseed sql identity
SQL
0 vote365 views1 answer
How to inner join 4 tables in sql
SQL
0 vote322 views1 answer
Tsql find procedure with name
SQL
1 vote322 views1 answer
Pagination sql
SQL
1 vote321 views1 answer
Sqlite check if row exists
SQL
0 vote297 views1 answer
How to install Firebird
SQL
0 vote325 views1 answer
Create query in where clasue
SQL
0 vote321 views1 answer
Mysql config slave
SQL
0 vote338 views3 answers
Classement rang mysql 7
SQL
1 vote312 views2 answers
DROP TABLes regardless of constraints
SQL