/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

18 votes304 views2 answers
Sql comments
SQL
0 vote275 views1 answer
Get last run query sql server
SQL
0 vote324 views1 answer
Oracle shrink table
SQL
54 votes523 views6 answers
Sql rename column
SQL
2 votes305 views1 answer
Mysql add boolean column
SQL
0 vote435 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote316 views1 answer
Mysql workbench not showing schemas
SQL
3 votes308 views2 answers
Coalesce mysql
SQL
9 votes355 views2 answers
Convert data type in sql
SQL
5 votes337 views2 answers
Postgres update with if condition query
SQL