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

0 vote309 views1 answer
User defined variables in sql
SQL
0 vote319 views1 answer
Get who is hired in february in sql
SQL
6 votes318 views2 answers
Non relational database
SQL
0 vote341 views1 answer
SQL server datetime compare
SQL
0 vote312 views1 answer
Sql server create constraint
SQL
16 votes325 views1 answer
Mysql reset auto increment value
SQL
0 vote302 views1 answer
Partitioning in oracle-base
SQL
0 vote286 views1 answer
How to remove default in mysql
SQL
1 vote295 views1 answer
Sql bitwise operators
SQL
2 votes303 views1 answer
Query to find table size in oracle 12c
SQL