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

4 votes350 views1 answer
Change nls_date_format
SQL
0 vote369 views1 answer
Insert or update sql firebird
SQL
2 votes316 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote428 views1 answer
Why do we need data structure in sql
SQL
1 vote383 views1 answer
Sql where max date
SQL
0 vote367 views2 answers
CREATE OR REPLACE FUNCTION
SQL
1 vote327 views1 answer
Foreign key in oracle sql developer
SQL
1 vote364 views1 answer
Oracle update with sequence
SQL
0 vote377 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote342 views1 answer
Mysql select last 15 minutes
SQL