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

0 vote203 views1 answer
Sql get count without group by
SQL
7 votes200 views1 answer
Postgres base size
SQL
1 vote246 views1 answer
Psql client write to bash variable
SQL
0 vote205 views1 answer
Sql shell psql cannot enter password
SQL
8 votes282 views1 answer
Oracle search code in packages
SQL
0 vote194 views1 answer
Postgres call view
SQL
3 votes230 views2 answers
Sql not contains
SQL
0 vote195 views1 answer
Create table if not exist with exceptions
SQL
0 vote213 views1 answer
Sql update subtract value
SQL
0 vote209 views1 answer
Sql column contains special character
SQL