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 vote247 views1 answer
Create index concurrently postgres
SQL
0 vote259 views1 answer
Connect to ssms with python
SQL
0 vote262 views2 answers
Laravel: customize or extend notifications - database model
SQL
0 vote271 views1 answer
Edit shchima table in sql
SQL
0 vote306 views1 answer
Mysql, how to query the table comments?
SQL
0 vote248 views2 answers
Plsql function that return a table
SQL
3 votes279 views2 answers
How to force truncate a table in mysql
SQL
36 votes261 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote277 views1 answer
Compare subqueries oracle
SQL
2 votes261 views1 answer
Grant revoke privileges to mysql username
SQL