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 vote236 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote273 views1 answer
How to write if case in select query in select statement
SQL
6 votes247 views1 answer
Allsource oracle
SQL
0 vote261 views1 answer
Sqlite version check
SQL
0 vote265 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
1 vote425 views1 answer
Postgres upgrade to superuser
SQL
0 vote260 views1 answer
Character count sql
SQL
0 vote304 views1 answer
Insert query return id mysql
SQL
0 vote270 views1 answer
Multiple replace value mssql
SQL
0 vote264 views1 answer
How to read the potentail error messages in ssis package
SQL