/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 vote176 views1 answer
Mysql select where text contains
SQL
1 vote203 views1 answer
Denied
SQL
0 vote184 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote180 views1 answer
Oracle index hint
SQL
0 vote230 views1 answer
Mysql c commands
SQL
4 votes191 views3 answers
How to describe a table in sqlite3
SQL
0 vote219 views1 answer
MySQL get all previous date record
SQL
0 vote190 views1 answer
Add timestamp column to existing table t-sql
SQL
14 votes197 views3 answers
Oracle sql limit results
SQL
6 votes188 views1 answer
Update left join mysql
SQL