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 vote290 views1 answer
Postgresql print variable
SQL
0 vote284 views1 answer
Update set with inner join oracle
SQL
0 vote354 views1 answer
Hierarchal database table
SQL
0 vote266 views2 answers
Avg() sql
SQL
0 vote291 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote320 views1 answer
Sql query wordpress export post
SQL
1 vote283 views3 answers
Postgresql connect to database
SQL
0 vote332 views1 answer
Select the date 30 days less that the todays date sql request
SQL
3 votes303 views1 answer
Set default today mysql
SQL
13 votes306 views1 answer
Fetch first 5 rows in oracle sql developer
SQL