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 vote370 views1 answer
Php insert null mysql
SQL
2 votes291 views1 answer
Sqlite3 show columns name
SQL
1 vote298 views1 answer
Postgresql append array
SQL
0 vote278 views1 answer
Sqlalchemy get ids
SQL
1 vote289 views1 answer
How to show index type in postgresql
SQL
0 vote268 views1 answer
On update current_timestamp jpa
SQL
0 vote272 views2 answers
Find lowest number in sql
SQL
1 vote279 views1 answer
Postgresql create table with timestamp
SQL
2 votes263 views1 answer
Get first 3 letters name in sql
SQL
10 votes301 views2 answers
Mysql alter add foreign key
SQL