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

7 votes140 views5 answers
Sql remove spaces
SQL
0 vote130 views1 answer
Postgresql delete multiple rows
SQL
0 vote137 views1 answer
Sql #region
SQL
0 vote124 views4 answers
Mysql count table rows
SQL
1 vote129 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
4 votes139 views2 answers
Delete all table oracle
SQL
0 vote136 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
1 vote125 views1 answer
Set mysql mode global query
SQL
0 vote128 views1 answer
Select from another database
SQL
1 vote154 views1 answer
Sql set auto increment back to 0
SQL