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

2 votes191 views1 answer
Set boolean flasksql
SQL
1 vote204 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote243 views1 answer
Tsql cte in a transaction
SQL
0 vote179 views1 answer
Sequelize postgresql schema
SQL
7 votes203 views2 answers
3rd height salary sql
SQL
1 vote192 views1 answer
Oracle avg
SQL
0 vote185 views2 answers
Default constraint in ms sql
SQL
0 vote210 views4 answers
What is unique key in sql
SQL
0 vote241 views1 answer
CONVERT time string into 12 hours in sql
SQL
0 vote189 views1 answer
Grant privileges of databse to user
SQL