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

3 votes222 views5 answers
No module named 'MySQLdb'
SQL
0 vote222 views1 answer
Pl/pgsql declare variable
SQL
0 vote175 views1 answer
Opensuse stop MySQL
SQL
-1 vote238 views4 answers
Sql view postgresql
SQL
2 votes219 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote190 views1 answer
Mysql repair a table
SQL
4 votes205 views3 answers
Mysql modify foreign key
SQL
7 votes211 views3 answers
SQL create a new table
SQL
6 votes249 views2 answers
How to get yesterday date in mysql
SQL
0 vote189 views1 answer
How to print mysql query of codeigniter query builder
SQL