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 vote231 views1 answer
ORACLE PARSE STRING
SQL
0 vote202 views1 answer
Find how many tables in database sql query
SQL
2 votes179 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
5 votes208 views3 answers
Db begintransaction laravel
SQL
0 vote226 views1 answer
How to check rollback status in oracle
SQL
6 votes183 views3 answers
Update with inner join postgres
SQL
0 vote230 views1 answer
MySQL update with subquery
SQL
1 vote188 views2 answers
Get table column names sql laravel
SQL
0 vote197 views1 answer
Python sqlalchemy connection show server
SQL
2 votes180 views1 answer
Columns Present in a table
SQL