Oracle select first row order by

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 vote112 views1 answer
Select the date 30 days less that the todays date sql request
SQL
1 vote135 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote150 views1 answer
For select oracle
SQL
0 vote126 views1 answer
SQL column name Oracle
SQL
0 vote116 views1 answer
Sql with example
SQL
0 vote116 views1 answer
Show database not empty tables postgres
SQL
-1 vote109 views1 answer
Round up and down sql
SQL
0 vote121 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
4 votes114 views1 answer
Check database name postgresql
SQL
0 vote117 views1 answer
No suitable driver found for sqlite
SQL