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 vote148 views1 answer
Mysql aspas simples
SQL
0 vote124 views1 answer
Sql insert tuple
SQL
4 votes136 views2 answers
Delete all table oracle
SQL
0 vote126 views1 answer
Delete insert record in sql server
SQL
0 vote119 views1 answer
Mysql find missing values
SQL
0 vote131 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote141 views1 answer
Sql query for login with email or username
SQL
-1 vote117 views3 answers
Mysql get age from date
SQL
10 votes131 views1 answer
Oracle object dependencies
SQL
3 votes139 views2 answers
Host is not allowed to connect to this mysql server
SQL