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 vote266 views1 answer
Sqlplus change user
SQL
0 vote227 views1 answer
Select mysql limit to 2 decimal places
SQL
0 vote262 views1 answer
Mysql check datetime equals date
SQL
3 votes249 views2 answers
WhereIn SQL
SQL
0 vote257 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote265 views1 answer
Check if database exists sql
SQL
1 vote267 views1 answer
Drop df constraint sql server
SQL
5 votes272 views2 answers
Postgres update with if condition query
SQL
12 votes267 views5 answers
Sql merge
SQL
0 vote244 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL