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

29 votes317 views6 answers
Delete all rows from table mysql
SQL
1 vote313 views1 answer
How to run parallel queries in sql server with entity framework
SQL
1 vote320 views1 answer
Postgres concat_ws
SQL
0 vote354 views1 answer
Get statis values sql
SQL
1 vote326 views3 answers
Get all tables postgres
SQL
0 vote362 views1 answer
Write SQL in ruby on rails
SQL
5 votes338 views3 answers
MySql get fields of table
SQL
1 vote335 views1 answer
How to start with sql
SQL
3 votes343 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote324 views1 answer
Oracle job class
SQL