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 vote122 views1 answer
Format the money fied with comma in international system using sql
SQL
3 votes107 views2 answers
Mysql HAVING
SQL
1 vote103 views1 answer
Database Queries
SQL
0 vote104 views1 answer
How to drop columns with constraint from a table in sql script
SQL
8 votes95 views1 answer
Oracle add month
SQL
0 vote99 views1 answer
Max length found in mysql
SQL
19 votes130 views6 answers
Create table sqlite
SQL
0 vote114 views1 answer
Flexible search query delete table
SQL
2 votes150 views3 answers
Mysql cheat sheet
SQL
0 vote112 views1 answer
Geopoint from json mysql function
SQL