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

2 votes99 views1 answer
How to delete columns in sql
SQL
0 vote129 views1 answer
Sql today at midnight
SQL
0 vote98 views4 answers
Mysql count table rows
SQL
0 vote107 views1 answer
Sql query contains multiple ids
SQL
4 votes111 views4 answers
Start mysql
SQL
0 vote104 views1 answer
Sql server check whether column has same equal values
SQL
49 votes197 views6 answers
Mysql add column to table
SQL
0 vote116 views1 answer
Mysql not defined
SQL
1 vote76 views3 answers
Grant syntax in sql
SQL
1 vote119 views1 answer
Oracle stop
SQL