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

34 votes345 views6 answers
Install mysql client ubuntu
SQL
1 vote333 views1 answer
How to delete data from sql database in android
SQL
1 vote313 views1 answer
Base nosql
SQL
-1 vote340 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
1 vote319 views3 answers
Reset sql primary key
SQL
0 vote347 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote312 views1 answer
How to change mysql port in xampp
SQL
1 vote332 views1 answer
Right outer vs left outer join
SQL
24 votes332 views4 answers
Delete db postgres
SQL
0 vote411 views1 answer
Current month transactions in mysql
SQL