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

7 votes336 views2 answers
What is sql clause
SQL
0 vote321 views2 answers
Drop check constraint in ms sql
SQL
2 votes358 views2 answers
Create empty table from existing table
SQL
19 votes352 views3 answers
How to change column type psql
SQL
9 votes317 views4 answers
Add primary key to existing table sql
SQL
0 vote333 views1 answer
Sql server concat null
SQL
1 vote335 views1 answer
Flask sqlalchemy default value
SQL
9 votes324 views4 answers
Last mysql
SQL
31 votes312 views3 answers
Sql count
SQL
3 votes366 views2 answers
Sqlite show table structure
SQL