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
Oracle job session
SQL
4 votes148 views2 answers
Bulk kill mysql processlist
SQL
0 vote80 views1 answer
FindAllBy
SQL
12 votes128 views4 answers
Mysql get date difference in hours
SQL
5 votes142 views1 answer
Commentaire table oracle
SQL
6 votes139 views2 answers
Stored procedure to delete data from table in mysql
SQL
-1 vote149 views1 answer
Mysql select count if contains
SQL
5 votes130 views1 answer
Sysdate in oracle sql
SQL
5 votes140 views1 answer
Sql use database
SQL
0 vote150 views1 answer
How to find table lock and row lock in mysql
SQL