/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 vote188 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote195 views1 answer
Test sql query
SQL
0 vote229 views1 answer
Doctors appointment
SQL
2 votes163 views2 answers
Mysql all columns
SQL
0 vote184 views1 answer
Sql decode
SQL
0 vote258 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote179 views1 answer
How to query all tables mysql at the same time
SQL
0 vote164 views1 answer
Set column width in sqlplus
SQL
0 vote152 views1 answer
Sql get month and year from date
SQL
0 vote169 views1 answer
Oracle sql log to console
SQL