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

22 votes120 views4 answers
Mysql date_format
SQL
0 vote117 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote142 views1 answer
Postgres full text search example
SQL
2 votes67 views1 answer
Mysql admin u root p password change password
SQL
12 votes118 views4 answers
Mysql version query
SQL
0 vote103 views1 answer
Sql examples from your work
SQL
0 vote110 views1 answer
Sql right characters
SQL
0 vote112 views1 answer
Mysql user set plugin
SQL
0 vote129 views1 answer
Postgresql linux password
SQL
0 vote120 views2 answers
Select index table oracle
SQL