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 vote170 views1 answer
Suhaib
SQL
0 vote132 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote175 views2 answers
How to prevent sql injection in java
SQL
0 vote134 views1 answer
Min and max salary and name in sql
SQL
1 vote288 views2 answers
Sql unique rows
SQL
1 vote143 views1 answer
Moodle query first user access
SQL
1 vote355 views1 answer
How to make a select in sql
SQL
2 votes148 views1 answer
Add new column not null sql server
SQL
0 vote149 views1 answer
How to check which table has data in mysql
SQL
-1 vote143 views1 answer
Count occurrences sql
SQL