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

1 vote193 views1 answer
Postgresql contains
SQL
-1 vote179 views1 answer
Search all database tables for a value sqlserver
SQL
4 votes179 views1 answer
Mysql copy table with new name
SQL
0 vote188 views1 answer
Flush user resource mysql
SQL
0 vote191 views2 answers
How to find sql server agent jobs related to a database
SQL
3 votes215 views3 answers
Docker create postgresql database
SQL
0 vote203 views1 answer
Query archive mode
SQL
0 vote186 views1 answer
Test the postgresql db connection
SQL
17 votes249 views6 answers
MySQL ORDER BY
SQL
0 vote224 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL