/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 vote284 views1 answer
Mysql show category once count how many products
SQL
0 vote283 views1 answer
C# add a textbox in mysql select
SQL
1 vote290 views1 answer
Right outer vs left outer join
SQL
0 vote269 views2 answers
Check mysql timezone
SQL
26 votes269 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote271 views1 answer
Sql server order by nulls last
SQL
0 vote287 views1 answer
Get enginge db mysql
SQL
32 votes343 views6 answers
Rename column mysql
SQL
3 votes270 views1 answer
Oracle rollback
SQL
0 vote285 views1 answer
Mysql master slave setup with keepalived
SQL