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

6 votes175 views2 answers
Non relational database
SQL
1 vote231 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote178 views1 answer
Sql on-premises
SQL
0 vote171 views2 answers
Clear window pl sql
SQL
1 vote170 views1 answer
SQLite order random
SQL
2 votes172 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote175 views1 answer
Mysql enter ubuntu
SQL
10 votes176 views4 answers
Inner join in update query mysql
SQL
0 vote176 views1 answer
Set column in all row mysql
SQL
7 votes191 views2 answers
Where keyword sql
SQL