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 vote237 views1 answer
Select even number id data from table
SQL
0 vote236 views2 answers
How to get the date from datetime in mysql
SQL
24 votes218 views4 answers
How to add column sql
SQL
0 vote224 views1 answer
Mysql server not running
SQL
18 votes231 views6 answers
Create table mysql
SQL
0 vote249 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote230 views1 answer
Where name ends in SQL
SQL
1 vote243 views1 answer
Create new index takes long time postgresql
SQL
11 votes213 views2 answers
Sql between date range
SQL
1 vote281 views4 answers
How to check table in postgresql from terminal
SQL