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 vote181 views1 answer
Ffeathers express mysql application users login
SQL
1 vote202 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote187 views1 answer
Mysql_union
SQL
2 votes177 views1 answer
Sql like variable
SQL
0 vote202 views1 answer
Python sqlalchemy connection show server
SQL
0 vote192 views1 answer
Mysql root permission denied lost
SQL
3 votes213 views1 answer
Oracle cannot access v$session
SQL
3 votes189 views1 answer
Get current month last date in sql server
SQL
34 votes234 views6 answers
Alter table add foreign key mysql
SQL
0 vote181 views1 answer
Azure sql server check foreign key
SQL