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 vote213 views1 answer
Oracle job session
SQL
0 vote194 views1 answer
Reset postgres table index to next max value
SQL
7 votes175 views5 answers
Oracle alter table
SQL
2 votes214 views1 answer
Orcale index size
SQL
0 vote174 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
1 vote166 views1 answer
Duplicating a MySQL table with all the data Command
SQL
1 vote164 views2 answers
Sql server add time to date
SQL
0 vote162 views1 answer
Mysql update sum same table
SQL
0 vote169 views1 answer
Mysql grant grant option
SQL
7 votes168 views2 answers
What is sql clause
SQL