Oracle select first result

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 vote200 views2 answers
Dumping sql table
SQL
2 votes189 views2 answers
Change varchar length mysql
SQL
3 votes186 views1 answer
Postgresql today - 1 year
SQL
5 votes189 views2 answers
Create table mysql example auto_increment
SQL
23 votes192 views3 answers
Sql where contains part of string
SQL
5 votes178 views1 answer
Mysql created at yesterdau
SQL
0 vote182 views1 answer
Add SuperUser MySQL
SQL
1 vote182 views2 answers
Last working day in week date function in sql
SQL
1 vote159 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
2 votes174 views1 answer
Postgresql format date dd/mm/yyyy
SQL