Oracle select first 10 rows

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

2 votes172 views2 answers
How to view created temporary tables in mysql
SQL
0 vote162 views2 answers
Sql last updated
SQL
0 vote180 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote169 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote167 views1 answer
Get last updated row sql server
SQL
0 vote177 views1 answer
How to print mysql query of codeigniter query builder
SQL
2 votes186 views1 answer
Dbms transaction (psql)
SQL
0 vote193 views1 answer
Sqlite woth cmake
SQL
0 vote169 views1 answer
SQL FROM-Klausel
SQL
0 vote208 views1 answer
Get total and distict row diff in sql
SQL