Oracle select first 10 rows

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

7 votes126 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote120 views3 answers
Magento 2 order delete from db
SQL
1 vote97 views1 answer
Sql server 2016 reseed identity
SQL
0 vote113 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote106 views1 answer
Suse status MySQL
SQL
2 votes97 views2 answers
Function in sql
SQL
5 votes97 views2 answers
Oracle list columns schema
SQL
1 vote353 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote107 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote103 views1 answer
Best way to bind parameters to SqlCommand C#
SQL