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 vote344 views2 answers
Sql join on wildcard
SQL
18 votes327 views4 answers
Foreign key mySql
SQL
0 vote307 views2 answers
Postgresql could not start server mac
SQL
2 votes341 views3 answers
Current month mysql query
SQL
1 vote353 views2 answers
Mssql show database size
SQL
2 votes354 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
13 votes322 views3 answers
Uninstall mysql centos 7
SQL
3 votes377 views2 answers
Check data in table mysql
SQL
0 vote359 views1 answer
Sql insert query list of dictionaries
SQL
10 votes392 views4 answers
Mysql if else
SQL