/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

8 votes122 views2 answers
Mysql get first x characters
SQL
4 votes122 views2 answers
How to count items with same name in sql
SQL
-1 vote114 views3 answers
Mysql get age from date
SQL
1 vote121 views3 answers
How to get date in sql
SQL
0 vote130 views1 answer
Recursive query herarchical data sql server
SQL
5 votes122 views2 answers
Copy data from one database to another
SQL
0 vote118 views1 answer
Get number of rows in every table mysql
SQL
0 vote129 views1 answer
Disableforiegn key check
SQL
0 vote130 views1 answer
Oracle allow space to user
SQL
0 vote125 views1 answer
Mysql sum per week
SQL