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 vote251 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
11 votes282 views2 answers
Insert current date sql
SQL
0 vote263 views1 answer
Get foreign table names mysql
SQL
24 votes284 views4 answers
Delete db postgres
SQL
1 vote264 views2 answers
Setval max id postgresql sequence
SQL
1 vote272 views1 answer
Mysql dump specific tables
SQL
0 vote272 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote261 views1 answer
Can we rollback deleted data in sql
SQL
22 votes279 views3 answers
SQL CHEATSHEET
SQL
3 votes421 views9 answers
Linq to sql converter online
SQL