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

1 vote325 views1 answer
Oracle stop
SQL
0 vote300 views2 answers
Cascade syntax in sql
SQL
0 vote320 views1 answer
Mysql export and import
SQL
0 vote339 views1 answer
How do I insert a blob in SQL?
SQL
0 vote329 views2 answers
Postgresql gset
SQL
1 vote302 views1 answer
Set statistics on in ssms
SQL
0 vote300 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
13 votes338 views3 answers
Insert mysql ifile nto database
SQL
1 vote314 views2 answers
Sql now - 1 day
SQL
2 votes312 views1 answer
Node and mysql like
SQL