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 vote146 views1 answer
Mysql with
SQL
0 vote163 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
16 votes156 views3 answers
Tsql rename column name
SQL
0 vote167 views2 answers
Greater than sql server
SQL
0 vote174 views1 answer
Mysql insert into select transaction c#
SQL
0 vote169 views1 answer
Sql server phone constraint
SQL
0 vote186 views1 answer
Mysql auto increment default value with prefix month and year
SQL
2 votes172 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote146 views1 answer
Sequelize postgresql schema
SQL
1 vote151 views1 answer
Delete mysql from mac
SQL