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 vote212 views1 answer
How to check all scheduled jobs in oracle
SQL
1 vote156 views1 answer
Sql insert for each distinct value
SQL
2 votes222 views1 answer
Merge two columns in sql oracle
SQL
4 votes172 views1 answer
Refresh postgres config
SQL
-1 vote225 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote167 views1 answer
Mysql two joins
SQL
3 votes167 views4 answers
Ubuntu stop mysql
SQL
0 vote170 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote169 views1 answer
Sql server select ignore dupplicates
SQL
3 votes160 views4 answers
Stop MySQL
SQL