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 vote271 views1 answer
Drop specific row postgresql
SQL
0 vote291 views1 answer
Alter table change default
SQL
0 vote262 views2 answers
MySQL top percent
SQL
0 vote264 views2 answers
Mysql output csv
SQL
5 votes277 views1 answer
Mysql created at yesterdau
SQL
0 vote258 views1 answer
Raiserror nowait sql server
SQL
1 vote285 views1 answer
Raise application error in oracle
SQL
0 vote275 views1 answer
Sql date d'aujourd'hui
SQL
1 vote265 views1 answer
How to drop function in sql
SQL
4 votes297 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL