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 views2 answers
Getting customers with no orders sql
SQL
-1 vote77 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote124 views2 answers
Update all columns in one update
SQL
0 vote124 views2 answers
Check mysql timezone
SQL
0 vote115 views1 answer
Output table plsql
SQL
0 vote120 views1 answer
Sql comand for removing data from table
SQL
0 vote121 views2 answers
Get all index postgres
SQL
-2 votes132 views1 answer
Remove root password mysql
SQL
0 vote133 views1 answer
Sql select all records from all tables where not empty
SQL
2 votes134 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL