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 vote356 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote367 views1 answer
Sql select lowest value row
SQL
4 votes337 views2 answers
Mysql show indexes on table
SQL
0 vote360 views1 answer
Sql character index
SQL
0 vote356 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote358 views1 answer
Get sum sqlite android
SQL
6 votes403 views2 answers
Foreign key sqlite3 python
SQL
1 vote337 views1 answer
How to select department from table
SQL
19 votes367 views3 answers
Grant mysql
SQL
0 vote370 views1 answer
How to select only a certain date sql
SQL