Oracle first row

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

1 vote141 views2 answers
Mysql extract month
SQL
0 vote148 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote141 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote133 views1 answer
Mysql find missing values
SQL
1 vote137 views1 answer
Sql where last 12 months
SQL
0 vote139 views1 answer
Select from 3 tables one is empty
SQL
0 vote143 views1 answer
Mysql date equals to current_date plus days
SQL
2 votes133 views1 answer
While loop sql
SQL
2 votes144 views1 answer
Mysql application.properties spring boot
SQL
4 votes133 views1 answer
Oracle show errors compilation
SQL