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 vote196 views1 answer
Inserted row count tsql
SQL
0 vote193 views1 answer
Original Query
SQL
0 vote202 views1 answer
Mysql min value row
SQL
3 votes172 views1 answer
Sql set null
SQL
2 votes206 views5 answers
SQL trigger
SQL
1 vote230 views1 answer
Concat first name and last name in mysql
SQL
8 votes190 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote156 views1 answer
Oracle sql developer script output limit
SQL
0 vote217 views1 answer
SQL joins in python
SQL
2 votes207 views1 answer
Cast string to datetime mysql
SQL