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

1 vote181 views1 answer
Drop function
SQL
26 votes436 views6 answers
Modify column name in sql
SQL
3 votes192 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote195 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
2 votes211 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote272 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote196 views1 answer
Postgres list all triggers
SQL
0 vote193 views1 answer
Check if database exists sql
SQL
0 vote181 views1 answer
Fill up postgres db
SQL
3 votes209 views2 answers
Mysql select database
SQL