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

4 votes331 views1 answer
Sql delete where in select
SQL
2 votes377 views1 answer
Where clause for child record apex
SQL
0 vote371 views2 answers
Execute stored procedure without db set
SQL
0 vote347 views1 answer
Sql get date from timestamp
SQL
1 vote342 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
0 vote359 views1 answer
Possgress drop if exists view
SQL
1 vote354 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote341 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote387 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote317 views1 answer
Mysql error codeigniter
SQL