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

4 votes287 views1 answer
Oracle session date format
SQL
0 vote291 views1 answer
Mariadb select limit offset
SQL
1 vote301 views1 answer
Oracle difference between two dates in years
SQL
0 vote287 views1 answer
Min mysql
SQL
0 vote296 views1 answer
Sql sum show 0 result
SQL
2 votes269 views1 answer
Username sql
SQL
5 votes307 views1 answer
Oracle add time to date
SQL
0 vote307 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
3 votes269 views3 answers
Mysqldump: couldn
SQL
1 vote273 views1 answer
T-SQL Alter the column data type
SQL