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

3 votes196 views3 answers
Raw select laravel
SQL
0 vote180 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote169 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
1 vote169 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote173 views1 answer
Createdb with postgresql on ubuntu
SQL
2 votes184 views1 answer
Drop sequence
SQL
1 vote206 views2 answers
Laravel jwt generate token
SQL
0 vote177 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote191 views1 answer
Mariadb change column type
SQL
6 votes170 views2 answers
Join vs union
SQL