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 vote262 views1 answer
Adding primery key constraint to a column
SQL
1 vote263 views2 answers
Mysql show views
SQL
0 vote261 views1 answer
Example of sql querry result sepapreted by comma
SQL
6 votes281 views1 answer
How to get the size of the database in postgresql
SQL
4 votes265 views3 answers
Mysql update with join
SQL
1 vote276 views1 answer
How to see which columns are indexxed mysql
SQL
0 vote248 views1 answer
Pl sql search saurce code
SQL
0 vote248 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote263 views1 answer
Sum values by month mariadb
SQL
0 vote271 views1 answer
Sql select lowest value row
SQL