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 vote347 views1 answer
Select max salary from each department in sql
SQL
0 vote356 views2 answers
Getting customers with no orders sql
SQL
0 vote380 views1 answer
Database db connection string format
SQL
1 vote373 views1 answer
Oracle sql average
SQL
5 votes393 views1 answer
Sql integer to serial
SQL
1 vote341 views1 answer
Mysql column start with string
SQL
1 vote406 views2 answers
Intersect sql
SQL
0 vote357 views1 answer
Sql server cannot create database diagram
SQL
1 vote376 views1 answer
Spark sql concatenate string and int
SQL
3 votes336 views2 answers
Mysql time
SQL