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 vote179 views1 answer
The local psql command could not be located
SQL
3 votes177 views1 answer
Oracle revoke
SQL
0 vote162 views1 answer
Hallo
SQL
1 vote188 views1 answer
Epoch time converter in snowflake
SQL
10 votes180 views1 answer
Dba_dependencies
SQL
0 vote191 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote198 views1 answer
Oracle drop type
SQL
1 vote146 views2 answers
Show sql logs in spring boot
SQL
1 vote177 views1 answer
Crontab every month
SQL
0 vote228 views1 answer
Reset a table's identity column and remove test records
SQL