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

4 votes283 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
3 votes266 views3 answers
Create a view postgres
SQL
0 vote274 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote284 views1 answer
Get only one row in mysql
SQL
0 vote286 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
6 votes220 views2 answers
Generate c# class from sql server table
SQL
3 votes285 views1 answer
APEX elapsed time
SQL
14 votes268 views1 answer
Oracle new column
SQL
16 votes338 views2 answers
Sql vs nosql
SQL
0 vote287 views1 answer
Mysql update all record removing 2 hours from column
SQL