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 vote196 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
0 vote188 views1 answer
Postgresql get diff between two dates in Months
SQL
1 vote182 views3 answers
Union SQL
SQL
0 vote193 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote201 views1 answer
What is top n result in sql
SQL
17 votes253 views6 answers
Get last record in sql
SQL
6 votes206 views3 answers
Mysql create database utf8
SQL
1 vote232 views1 answer
Postgresql where datetrunc month and year equal
SQL
6 votes182 views6 answers
Count mysql
SQL
2 votes201 views3 answers
Sql interview query questions
SQL