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

11 votes369 views2 answers
Insert current date sql
SQL
0 vote375 views1 answer
Oracle 11g forget password
SQL
0 vote389 views1 answer
Login failed for user sql server
SQL
0 vote364 views1 answer
Table values functions in SQL
SQL
0 vote349 views1 answer
Add timestamp column to existing table ms sql server
SQL
4 votes351 views4 answers
Update select mysql
SQL
1 vote345 views1 answer
Local sql server
SQL
0 vote335 views1 answer
Postgresql copy backup table
SQL
0 vote346 views1 answer
Mssql describe stored procedure sqlcmd
SQL
4 votes370 views1 answer
T-sql get duplicate rows
SQL