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 vote276 views1 answer
Rabbitmq service not starting
SQL
2 votes288 views2 answers
Mysql show table column comments sql
SQL
4 votes283 views1 answer
What are the data types in sql
SQL
4 votes286 views1 answer
Mysql timestamp in laravel migration
SQL
1 vote291 views1 answer
Get table column names sql ssms
SQL
0 vote297 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote293 views1 answer
Sql query to find duplicate email address
SQL
-1 vote282 views1 answer
Add column alter table default value
SQL
2 votes306 views4 answers
Check timezone of mysql database
SQL
1 vote286 views2 answers
ImportError: No module named mysql.connector
SQL