/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 vote98 views1 answer
Convert rows to columns in sql server
SQL
42 votes171 views6 answers
Sql query duplicate rows
SQL
0 vote114 views1 answer
View to table sql
SQL
0 vote98 views1 answer
Postrgres trunc
SQL
3 votes114 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote110 views1 answer
Oracle c# multiple update sql
SQL
0 vote123 views1 answer
On delete set default
SQL
19 votes103 views4 answers
Rename database in sql
SQL
1 vote107 views1 answer
How to remove identity from a column in sql server
SQL
0 vote98 views1 answer
Sql clear table
SQL