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

1 vote158 views1 answer
Sqlalchemy order_by
SQL
0 vote237 views1 answer
ORA-00942
SQL
3 votes175 views1 answer
Force using index oracle
SQL
2 votes147 views1 answer
Oracle current date without time
SQL
3 votes107 views1 answer
Postgresql where current year
SQL
14 votes156 views3 answers
SQL trim
SQL
0 vote148 views1 answer
Renommer table sql
SQL
0 vote159 views1 answer
Mysql group by range
SQL
-1 vote148 views1 answer
Round up and down sql
SQL
1 vote311 views3 answers
Sql subquery
SQL