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 vote290 views1 answer
Syntax for changing column size in mysql
SQL
1 vote304 views3 answers
Showing all columns in an sqlite table
SQL
0 vote253 views1 answer
Bigquery information_schema schema all columns
SQL
-1 vote324 views1 answer
Pl/sql how to delete a trigger
SQL
1 vote293 views2 answers
Mssql show database size
SQL
0 vote296 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote326 views1 answer
Mysql edit trigger
SQL
3 votes298 views3 answers
List columns in table postgres
SQL
8 votes280 views1 answer
Alter tablespace add datafile
SQL
0 vote307 views2 answers
Mysql on update current_timestamp
SQL