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 vote158 views1 answer
Order by in codeigniter query builder
SQL
1 vote157 views1 answer
Oracle grant on all tables in schema
SQL
0 vote154 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
2 votes156 views1 answer
Mysql sysdate - 1 day
SQL
2 votes170 views1 answer
Where clause for child record apex
SQL
0 vote112 views4 answers
Sql limit 1 offset 1
SQL
0 vote212 views1 answer
Postgres select from values
SQL
5 votes144 views1 answer
Sql select ciunt
SQL
1 vote156 views1 answer
Sql pick random row
SQL
0 vote142 views1 answer
Mysql select statement after index
SQL