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 vote151 views1 answer
Openquery update linked server
SQL
-1 vote132 views3 answers
Update mongodb version ubuntu
SQL
0 vote140 views1 answer
Postgresql array to rows
SQL
4 votes141 views1 answer
Oracle nls_date_format
SQL
0 vote133 views1 answer
Show all mongodb
SQL
1 vote126 views1 answer
Oracle select first result
SQL
0 vote122 views1 answer
Psql check if value in array
SQL
0 vote129 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
2 votes136 views1 answer
Mariadb select multiple rows into one column
SQL
1 vote125 views1 answer
Postgresql substring last
SQL