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 vote138 views1 answer
Sql server system messeges
SQL
1 vote107 views1 answer
Sample in sql
SQL
0 vote104 views1 answer
Select password from user mysql
SQL
1 vote104 views2 answers
Mysql join two tables
SQL
0 vote140 views1 answer
Compare strings lexicographically in sql
SQL
0 vote100 views1 answer
Order by ip address sql
SQL
0 vote96 views1 answer
Get sum sqlite android
SQL
0 vote103 views1 answer
Mssql now diff 90 day
SQL
0 vote115 views1 answer
Intellij idea add mysql connector
SQL
0 vote103 views1 answer
Equi joins in oracle
SQL