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

1 vote341 views1 answer
Pv mysql import
SQL
1 vote338 views1 answer
Sqlite3 read only
SQL
-1 vote350 views1 answer
How to switch user in mysql
SQL
0 vote358 views1 answer
Sparql if bound query
SQL
1 vote372 views1 answer
Mysql previous year
SQL
0 vote378 views1 answer
Openquery update linked server
SQL
4 votes408 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
5 votes362 views1 answer
Mysql created at yesterdau
SQL
0 vote365 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
12 votes352 views2 answers
Update column data type postgres
SQL