Oracle first row

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

12 votes270 views4 answers
SQL Where
SQL
2 votes300 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote314 views1 answer
Drop index in sql
SQL
0 vote300 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote339 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
1 vote296 views1 answer
Postgresql delete cascade
SQL
0 vote327 views2 answers
Mysql dump database tables only
SQL
0 vote365 views1 answer
Delete ids between sql
SQL
6 votes298 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote308 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL