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

1 vote133 views1 answer
How to set up a trigger in sql
SQL
0 vote167 views1 answer
Get statis values sql
SQL
0 vote141 views2 answers
Mysql dump structure only
SQL
0 vote126 views1 answer
Mysql trim characters
SQL
0 vote158 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote133 views1 answer
Mysql set boolean default value
SQL
0 vote124 views1 answer
Sql server remove 0 from left
SQL
9 votes130 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
3 votes163 views3 answers
Create table in SQL Server
SQL
-1 vote157 views3 answers
Error: mysql shutdown unexpectedly.
SQL