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

50 votes290 views6 answers
Install mysql on ubuntu
SQL
0 vote187 views1 answer
Char vs varchar2 in sql
SQL
92 votes2.3K views6 answers
Substring
SQL
0 vote208 views2 answers
Athena drop partition
SQL
1 vote198 views1 answer
Sql select where id not exists in another table
SQL
9 votes210 views5 answers
Laravel to sql
SQL
17 votes256 views6 answers
MySQL ORDER BY
SQL
0 vote179 views1 answer
VSCode SQL Server Connection error
SQL
0 vote217 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote249 views1 answer
Sql to excel pgadmin
SQL