/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

1 vote125 views2 answers
Oracle list service names
SQL
0 vote101 views1 answer
Sql gap missing values
SQL
8 votes141 views1 answer
Mysql limit rows
SQL
2 votes105 views1 answer
Sql ignore accents
SQL
0 vote116 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote116 views1 answer
Add sqlite3 in lumen
SQL
0 vote165 views1 answer
Copy from one table to another postgres using matching column
SQL
1 vote119 views2 answers
T sql get foreign key
SQL
0 vote111 views1 answer
Mysql into outfile with headers
SQL
1 vote118 views1 answer
How to select the nth row in a SQL database table?
SQL