/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

8 votes133 views2 answers
Update sql server from another table
SQL
6 votes133 views1 answer
Oracle trigger after logon on database
SQL
0 vote131 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
7 votes263 views2 answers
Drop index oracle
SQL
0 vote157 views1 answer
What is common table expression in sql
SQL
10 votes148 views2 answers
Forgot my mysql password mac
SQL
7 votes139 views4 answers
How to reset the identity column in sql server
SQL
2 votes123 views1 answer
How to delete columns in sql
SQL
0 vote132 views1 answer
Sql server manager close connection
SQL
1 vote179 views1 answer
Pgsql sum switch case
SQL