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

0 vote345 views1 answer
Ajax error exception handeling
SQL
9 votes400 views3 answers
Sql delete where in
SQL
1 vote365 views2 answers
Postgres cast as decimal
SQL
5 votes385 views2 answers
Mysql dump mysql db cli
SQL
5 votes342 views1 answer
Sqlite alter table add column
SQL
1 vote383 views1 answer
Last 24 HOUR data in mysql
SQL
5 votes328 views2 answers
Mysql drop table cascade
SQL
5 votes356 views2 answers
Get number of columns sql
SQL
0 vote343 views1 answer
Power bi find all ids not in other tables
SQL
0 vote357 views1 answer
Alter domain sql
SQL