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

0 vote107 views1 answer
Addition of 2 column value in mysql
SQL
0 vote152 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
18 votes109 views6 answers
Creating table in MySQL
SQL
0 vote180 views1 answer
Sql insert exemplo
SQL
2 votes107 views1 answer
Drop table purge
SQL
19 votes105 views2 answers
Mysql add column after another
SQL
0 vote110 views2 answers
Alter table add multiple columns mysql
SQL
0 vote103 views1 answer
Like sql for second letter of the family name
SQL
1 vote55 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote153 views1 answer
Mysql faster delete
SQL