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

5 votes246 views2 answers
Mysql dump mysql db cli
SQL
2 votes232 views4 answers
2nd highest salary in mysql
SQL
-1 vote226 views1 answer
Partial search in sql
SQL
0 vote227 views1 answer
Oracle list of long running queries
SQL
3 votes235 views1 answer
Postgres add not null to existing column
SQL
22 votes254 views3 answers
How to join three tables in sql using joins
SQL
0 vote247 views1 answer
PostgreSQL types and C# types
SQL
0 vote216 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote239 views2 answers
Mysql calcular idade
SQL
1 vote209 views1 answer
GROUP BY clause; this is incompati
SQL