/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

16 votes237 views4 answers
Sort by sql
SQL
0 vote277 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote248 views1 answer
ORA-00942
SQL
1 vote227 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote265 views1 answer
How to find date from date table in sql
SQL
1 vote240 views1 answer
ALL_TAB_PARTITIONS
SQL
-1 vote207 views1 answer
Plsql while
SQL
12 votes236 views2 answers
Delete entries in postgresql
SQL
1 vote222 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote240 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL