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

0 vote264 views1 answer
How to check if there is no database schema
SQL
0 vote298 views1 answer
Mysql user set plugin
SQL
10 votes275 views2 answers
Forgot my mysql password mac
SQL
0 vote268 views3 answers
Between keyword sql
SQL
0 vote314 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote279 views2 answers
Get top 1 row of each group
SQL
3 votes263 views3 answers
Stop mysql service ubuntu
SQL
16 votes261 views2 answers
Gremove folder from git
SQL
0 vote272 views1 answer
Mysql find missing values
SQL
9 votes301 views3 answers
Date format in sql
SQL