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

1 vote238 views4 answers
How to check table in postgresql from terminal
SQL
0 vote171 views1 answer
Stop psql server windows
SQL
0 vote192 views1 answer
Alter check command
SQL
0 vote178 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
8 votes172 views1 answer
Mac restore mysql database command line
SQL
3 votes173 views4 answers
Show sql server database
SQL
12 votes170 views1 answer
Env var for setting password for root user mysql docker hub
SQL
1 vote182 views1 answer
SQL query to get all table records count from a database
SQL
1 vote187 views5 answers
What is in operator in sql
SQL
0 vote199 views1 answer
Automated psql csv export script on windows
SQL