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
Extract sql from query object sqlalchemy
SQL
0 vote133 views1 answer
Sql constarint
SQL
7 votes142 views3 answers
Select latest entry in sql table
SQL
3 votes142 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote140 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote149 views1 answer
T sql check active deadlock
SQL
0 vote146 views1 answer
SQL server datetime compare
SQL
0 vote140 views1 answer
SQL isnumeric DB2
SQL
0 vote133 views1 answer
Postgresql isnull with max
SQL
-1 vote144 views1 answer
Sql select data from one database and insert into a different database
SQL