/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 vote349 views1 answer
Mysql find missing values
SQL
4 votes323 views1 answer
Mac install mysql
SQL
3 votes359 views1 answer
Set default today mysql
SQL
0 vote367 views1 answer
Oracle array
SQL
3 votes356 views2 answers
Get current year sql
SQL
12 votes409 views4 answers
How to drop all tables in postgresql
SQL
0 vote365 views1 answer
Get date from timestamp in mysql
SQL
9 votes351 views4 answers
How to create new user and database postgresql in ubuntu
SQL
1 vote403 views1 answer
Oracle show execution plan
SQL
0 vote396 views1 answer
Change date format in oracle query
SQL