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 vote222 views1 answer
Oracle sql winter time change
SQL
1 vote176 views1 answer
Ms sql - add one hour to time
SQL
5 votes223 views1 answer
How to check nls format in oracle
SQL
4 votes251 views3 answers
Sql drop database if exists
SQL
1 vote241 views1 answer
Round function in sql oracle
SQL
2 votes232 views1 answer
Add default sql server
SQL
1 vote222 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote236 views1 answer
Create table sql generator
SQL
1 vote225 views1 answer
Mysql limit results to 10
SQL
3 votes237 views3 answers
Start postgresql ubuntu
SQL