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

1 vote312 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
0 vote275 views1 answer
Ora 00001 error catch plsql
SQL
0 vote280 views1 answer
See Foreign Key
SQL
5 votes299 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote267 views1 answer
Postgresql copy backup table
SQL
1 vote334 views1 answer
UseSqlServer no definition
SQL
0 vote281 views1 answer
Connect postgresql using a connection string
SQL
0 vote285 views2 answers
Mysql create table if not exists
SQL
-1 vote294 views3 answers
SQL MM/dd/yyyy format
SQL
6 votes330 views5 answers
Oracle list tablespaces
SQL