Oracle select first row order by

SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC)
    WHERE ROWNUM = 1;
-- Oracle 12c:
SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC) 
    FETCH FIRST 1 ROW ONLY;
SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC) 
    FETCH FIRST 10 ROW ONLY;
SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC) 
    FETCH FIRST 10 ROWS ONLY;

Similar codes

0 vote203 views1 answer
Oracle chain step succeeded
SQL
0 vote163 views1 answer
Output to file mysql
SQL
3 votes242 views2 answers
Oracle privileges users
SQL
0 vote184 views1 answer
Mysql docker image arjun
SQL
1 vote177 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote180 views1 answer
SQL isnumeric DB2
SQL
2 votes185 views1 answer
How to get weekday from old date in sql
SQL
0 vote222 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote9.7K views1 answer
Postgresql delete type
SQL
4 votes200 views1 answer
List tables sqlite
SQL