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

5 votes188 views2 answers
Add column postgres with default value
SQL
2 votes200 views1 answer
Delete all value query
SQL
0 vote227 views4 answers
What is unique key in sql
SQL
0 vote218 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote193 views1 answer
Update using case in mysql
SQL
0 vote221 views2 answers
How to drop mili second in sql
SQL
0 vote206 views2 answers
Laravel: customize or extend notifications - database model
SQL
0 vote204 views2 answers
Sql update top 100
SQL
0 vote215 views1 answer
Timestamp(0) postgresql
SQL
2 votes269 views1 answer
Merge two columns in sql oracle
SQL