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 vote148 views1 answer
Procedures sql insert mysql
SQL
0 vote168 views3 answers
Constraint sql
SQL
2 votes145 views2 answers
Postgres trigger insert into another table
SQL
0 vote163 views1 answer
Sql track modification
SQL
1 vote140 views1 answer
How to drop function in sql
SQL
11 votes142 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote164 views1 answer
How to to get time in sql
SQL
0 vote141 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote142 views1 answer
Mysql 1 hour ago
SQL
3 votes157 views1 answer
Increment integer in table sql
SQL