/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

26 votes106 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote107 views1 answer
How to move a columns location in mysql
SQL
0 vote154 views1 answer
Drop a view in sqlite
SQL
1 vote106 views1 answer
How to open closed port mysql in ubuntu
SQL
2 votes125 views1 answer
Column names in oracle sql
SQL
0 vote68 views1 answer
Sql select rows with simlar names
SQL
8 votes98 views1 answer
Sql remove characters from string right
SQL
1 vote131 views2 answers
Mysql add column tinyint default 0
SQL
57 votes269 views5 answers
How to create a new user in postgresql
SQL
15 votes115 views2 answers
Select where duplicate mysql
SQL