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

4 votes217 views1 answer
Postgresql create table with index
SQL
0 vote213 views1 answer
Acual month sql
SQL
-1 vote231 views1 answer
Minus vs except in sql
SQL
0 vote248 views1 answer
Combine 2 columns search query mysql
SQL
2 votes248 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote211 views2 answers
Update all linkedserver tables with openquery on db
SQL
42 votes264 views6 answers
Rename table sql server
SQL
1 vote227 views5 answers
What is in operator in sql
SQL
0 vote223 views1 answer
Get yesterday date ISO in psql
SQL
0 vote237 views1 answer
T sql dynamic top n query
SQL