/SQL/Fetch first 10 rows in oracle sql developer

Fetch first 10 rows in oracle sql developer

SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC)
    WHERE ROWNUM >= 1 AND ROWNUM <=10;
-- Oracle 12c:
SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC) 
    FETCH FIRST 10 ROWS ONLY;

Similar codes

21 votes354 views3 answers
Average sql
SQL
0 vote373 views1 answer
Mysql server not starting in xampp in mac
SQL
0 vote424 views1 answer
Finding leap year in sql
SQL
1 vote374 views1 answer
Generate random data postgresql
SQL
0 vote380 views1 answer
Nvl2 syntax
SQL
0 vote367 views3 answers
Sql query checker
SQL
7 votes398 views4 answers
Index in mysql
SQL
0 vote350 views1 answer
How to save data in database in mysql node
SQL
0 vote370 views1 answer
Restore backup mysql .gz
SQL
0 vote406 views1 answer
How to convert external table to managed table in hive
SQL