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

2 votes190 views1 answer
Express api ith mysql data
SQL
2 votes169 views1 answer
Oracle table size
SQL
24 votes181 views4 answers
Mssql get all table names
SQL
0 vote171 views1 answer
Can we rollback deleted data in sql
SQL
1 vote181 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote219 views1 answer
Sql server sleep
SQL
6 votes168 views3 answers
Can you update NULL in sql
SQL
0 vote212 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote164 views1 answer
Partitioning in oracle-base
SQL
40 votes243 views6 answers
Update table mysql
SQL