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 vote156 views1 answer
Luu ckeditor vao mysql
SQL
5 votes161 views2 answers
Sql server check port number
SQL
12 votes153 views2 answers
Delete entries in postgresql
SQL
0 vote163 views1 answer
Vbscript connect mssql
SQL
0 vote228 views1 answer
How to add auto increment primary key
SQL
1 vote145 views1 answer
Floor function in sql oracle
SQL
3 votes167 views1 answer
V$session not found in oracle
SQL
14 votes169 views6 answers
Auto_increment mysql
SQL
0 vote364 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote170 views1 answer
Oracle grant create job
SQL