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 votes348 views2 answers
Brew restart mysql
SQL
0 vote417 views2 answers
Mysql insert rows to another database
SQL
1 vote354 views4 answers
Alter schema sql
SQL
2 votes369 views4 answers
Check timezone of mysql database
SQL
0 vote413 views1 answer
Query only first letter string
SQL
26 votes353 views2 answers
Mysql workbench download
SQL
0 vote364 views1 answer
Alter boolean column postgresql
SQL
2 votes347 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote330 views1 answer
Postgresql add not null and not empty constraint
SQL
3 votes394 views6 answers
DB::table('users')->get();
SQL