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

13 votes111 views1 answer
Select count of distinct values sql
SQL
2 votes104 views1 answer
Pandas to sql index
SQL
0 vote128 views2 answers
How to see table associated with a schema in sql
SQL
0 vote117 views1 answer
Sql script to remove default from column
SQL
0 vote113 views1 answer
Python connect microsoft sql server
SQL
0 vote112 views1 answer
Default value false mysql
SQL
1 vote108 views1 answer
Mysql find tables with column name
SQL
1 vote110 views1 answer
Oracle index partition
SQL
0 vote108 views1 answer
Test sql query
SQL
0 vote144 views1 answer
Ora 00001 error catch plsql
SQL