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 vote91 views1 answer
Tsql generate rows
SQL
0 vote105 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
-1 vote100 views1 answer
Sql add column bit
SQL
0 vote102 views1 answer
Fast sql column count
SQL
0 vote134 views1 answer
Oracle sqlp update amount / quantity
SQL
4 votes90 views4 answers
Rollback in sql
SQL
0 vote102 views2 answers
Postgresql get last day of month
SQL
0 vote96 views1 answer
Database xml sql
SQL
1 vote106 views2 answers
Login to mysql
SQL
0 vote57 views1 answer
Split a string with expression and get the last value of split sql
SQL