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 vote253 views1 answer
Sqlite woth cmake
SQL
3 votes148 views2 answers
Sql end of month
SQL
0 vote156 views1 answer
Oracle list partitions
SQL
0 vote177 views1 answer
Eliminate zero from integer mysql
SQL
0 vote160 views1 answer
PGSQL dynamic table name
SQL
3 votes158 views6 answers
DB::table('users')->get();
SQL
0 vote152 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote140 views1 answer
Sql compound operators
SQL
3 votes155 views2 answers
Host is not allowed to connect to this mysql server
SQL
-1 vote105 views1 answer
Mysql how to set update or create
SQL