/SQL/Fetch first 10 rows in oracle sql developer

Fetch first 10 rows in oracle sql developer

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 vote330 views2 answers
Show slave status mysql
SQL
7 votes356 views1 answer
Oracle reset sequence
SQL
0 vote345 views1 answer
Dump db only triggers mysql
SQL
1 vote346 views2 answers
Mysql: command not found
SQL
0 vote333 views1 answer
Increment id in mysql
SQL
45 votes421 views5 answers
Grant all privileges mysql
SQL
0 vote331 views2 answers
Sql regex vowel
SQL
0 vote338 views2 answers
How to update the multiple rows in sql
SQL
0 vote352 views1 answer
VSCode SQL Server Connection error
SQL
0 vote385 views1 answer
Postgres meta command to show all rows in table
SQL