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

1 vote216 views1 answer
Truncate table in postgresql and reset id
SQL
6 votes156 views2 answers
Mysql timestamp to date
SQL
0 vote135 views1 answer
Oracle query archive mode
SQL
0 vote137 views1 answer
Mysql export search results
SQL
0 vote149 views1 answer
Postgresql in vs any performance
SQL
0 vote137 views1 answer
Set default value now() date
SQL
20 votes152 views4 answers
Sql count if
SQL
0 vote166 views1 answer
Time data type in mysql
SQL
2 votes124 views2 answers
Get all columns from table sql
SQL
13 votes147 views2 answers
Sql online compiler
SQL