Oracle first row

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

9 votes221 views2 answers
Oracle all tables in schema
SQL
0 vote187 views1 answer
Mql5 list all available symbols
SQL
0 vote240 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote186 views1 answer
Check index sql server
SQL
0 vote193 views1 answer
Hive batch drop table
SQL
0 vote251 views1 answer
Mysql subtract month from timestamp
SQL
3 votes201 views1 answer
Show index table
SQL
0 vote194 views1 answer
Mysql docker image for macbook m1
SQL
4 votes210 views2 answers
Float postgres
SQL
65 votes568 views6 answers
Sql add column to table
SQL