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

16 votes184 views4 answers
Find duplicates mysql
SQL
1 vote146 views1 answer
Operator does not exist: integer = text
SQL
1 vote252 views1 answer
Mysql data from file
SQL
0 vote152 views3 answers
Postgresql allow remote connections
SQL
0 vote155 views1 answer
Sql select random procentage from rows
SQL
0 vote152 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote164 views1 answer
Sql_inner_join
SQL
0 vote139 views1 answer
How to install postgresql on wsl
SQL
2 votes147 views4 answers
Mysql select into new table
SQL
1 vote144 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL