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 vote124 views1 answer
Selecting Data in SQL - Select Data
SQL
-1 vote135 views1 answer
Io
SQL
3 votes146 views2 answers
Host is not allowed to connect to this mysql server
SQL
1 vote140 views1 answer
Tsql get beginning of year
SQL
0 vote146 views1 answer
Mysql average from two table
SQL
0 vote137 views1 answer
Mysql count by month
SQL
0 vote205 views1 answer
Sql to search who modified
SQL
0 vote136 views1 answer
Foreign key type uniqu mysql
SQL
0 vote146 views1 answer
Hoq to import database source
SQL
1 vote179 views1 answer
Pgsql sum switch case
SQL