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 vote225 views1 answer
Mysql sql select one day before
SQL
7 votes228 views6 answers
Group_concat mysql
SQL
8 votes190 views8 answers
Second highest salary in mysql
SQL
2 votes211 views2 answers
Function in sql
SQL
1 vote258 views1 answer
Mysql find most common value
SQL
0 vote222 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote214 views1 answer
Oracle drop default value
SQL
4 votes219 views3 answers
Order by value mysql
SQL
0 vote186 views0 answer
How to connect to datbase in springboot
SQL
0 vote260 views1 answer
Parent and child link in mysql
SQL