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

10 votes294 views2 answers
Mysql alter add foreign key
SQL
0 vote295 views1 answer
Sql get latest of 2 datetimes
SQL
0 vote271 views1 answer
Mysql drop vs delete
SQL
0 vote290 views1 answer
Left join vs inner join performance
SQL
0 vote276 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote317 views1 answer
Kimball data warehouse sql calendar
SQL
4 votes314 views3 answers
Postgres drop all tables
SQL
1 vote299 views1 answer
Get current date in pyspark sql
SQL
18 votes266 views6 answers
Drop table if exists
SQL
0 vote268 views1 answer
Sql server count all tables rows
SQL