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

2 votes196 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote326 views1 answer
Provera dupliranih konatakata
SQL
0 vote203 views1 answer
Drop database using terminal postgres
SQL
0 vote253 views1 answer
Truncate a table then insert data
SQL
7 votes188 views1 answer
Sql management studio display line numbers
SQL
0 vote208 views1 answer
Sql #region
SQL
0 vote200 views1 answer
Oracle procedure teamplate
SQL
32 votes199 views6 answers
Insert into values select
SQL
3 votes241 views1 answer
Export postgres database linux
SQL
0 vote186 views1 answer
Mysql sql select one day before
SQL