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 vote360 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
2 votes377 views1 answer
Where clause for child record apex
SQL
0 vote339 views1 answer
Oracle sql date winter time
SQL
0 vote320 views1 answer
Deny select insert update delete sql
SQL
2 votes336 views1 answer
Date conversion in mysql column
SQL
0 vote336 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
2 votes332 views1 answer
Copy all values of a column to another column in sql in same table
SQL
1 vote353 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote359 views1 answer
Sql date time query find
SQL
0 vote355 views1 answer
Oracle list of long running queries
SQL