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

1 vote237 views1 answer
Insert column after column mysql
SQL
2 votes251 views2 answers
Mysql search for column name in all tables
SQL
0 vote261 views1 answer
Check if mysql db is used
SQL
0 vote267 views1 answer
Mysql faster delete
SQL
0 vote226 views1 answer
Mysql select all table that have field names
SQL
0 vote265 views1 answer
Sql column contains special character
SQL
0 vote224 views1 answer
Oracle last character of string
SQL
2 votes217 views1 answer
Convert series number to date in sql
SQL
1 vote224 views1 answer
Scaffold mysql database
SQL
0 vote240 views1 answer
Mysql export search results
SQL