/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

0 vote227 views1 answer
Reindex mssql table
SQL
0 vote242 views1 answer
Min varias colunas spark sql
SQL
8 votes201 views1 answer
Sql remove leading spaces
SQL
0 vote202 views2 answers
How to update the multiple rows in sql
SQL
-1 vote202 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
1 vote253 views1 answer
Add time to date sql
SQL
2 votes286 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote229 views1 answer
Oracle date summer time
SQL
0 vote205 views1 answer
How to query without duplicate rows in sql
SQL
0 vote205 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL