/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 vote238 views1 answer
Sql select row with max date
SQL
0 vote226 views1 answer
Cannot pip install mysqlclient
SQL
7 votes231 views2 answers
Sql remove duplicates based on column
SQL
1 vote204 views1 answer
Sql server update column based on another table
SQL
11 votes194 views1 answer
How to get ddl for materialized view
SQL
2 votes202 views3 answers
Postgresql reset auto increment
SQL
0 vote205 views2 answers
Close external port 3306 with iptables
SQL
2 votes200 views1 answer
Oracle sql concatenate results into string
SQL
0 vote212 views1 answer
Watch mysql command line
SQL
4 votes200 views1 answer
Delete record mysql query
SQL