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

2 votes202 views1 answer
How to search table name in stored procedure in sql server
SQL
2 votes206 views3 answers
How to pass password mysql command line
SQL
0 vote199 views1 answer
Contraint default SQL
SQL
56 votes369 views5 answers
Psql create user
SQL
0 vote206 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote184 views1 answer
Mysql does collate nopad recognize space
SQL
2 votes250 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote187 views1 answer
Oracle activate program
SQL
1 vote207 views1 answer
Float precision in psql
SQL
6 votes217 views2 answers
Postgresql restore from dump
SQL