Oracle select first row order by

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

5 votes208 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote156 views2 answers
Sql update from two different database
SQL
-2 votes195 views1 answer
Use of where in left join in mysql
SQL
1 vote196 views1 answer
Oracle duration between timestamps
SQL
0 vote183 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
1 vote229 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
9 votes214 views4 answers
SQL Date Format
SQL
0 vote194 views1 answer
Hibernate with springboot mysql
SQL
0 vote253 views1 answer
Get initials name in sql
SQL
0 vote188 views1 answer
Import all databases mysql
SQL