/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

14 votes209 views3 answers
How to add default constraint in mysql
SQL
0 vote199 views1 answer
Postgresql update to unique
SQL
0 vote194 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote187 views1 answer
Grepper sql workbench download
SQL
2 votes209 views1 answer
How to show the whole table in sql
SQL
0 vote197 views1 answer
Mysql update from n to 100
SQL
0 vote193 views1 answer
Sql change date format
SQL
2 votes181 views1 answer
Get first 2 letter in sql
SQL
0 vote196 views1 answer
Sqlplus change user
SQL
0 vote258 views1 answer
Mysql sum per week
SQL