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

3 votes241 views2 answers
Get current year sql
SQL
0 vote229 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote231 views1 answer
Mysql pv progres
SQL
0 vote225 views1 answer
Soql update query
SQL
0 vote224 views1 answer
T sql return on letters only
SQL
11 votes256 views5 answers
Sql server reset identity
SQL
13 votes250 views2 answers
Sqlite rename table
SQL
6 votes278 views2 answers
Mysql convert timestamp to date
SQL
16 votes259 views2 answers
Mysql date between two dates
SQL
0 vote228 views1 answer
Sql server remove enter from string
SQL