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 vote180 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
9 votes185 views5 answers
Sql limit
SQL
0 vote184 views1 answer
Drop CHECK constraint sql
SQL
0 vote160 views1 answer
Sql examples from your work
SQL
4 votes177 views1 answer
Change nls_date_format
SQL
2 votes171 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
10 votes183 views6 answers
Between sql
SQL
0 vote182 views1 answer
Selecting from a view SQL
SQL
1 vote180 views1 answer
How to find median of a column sql
SQL
0 vote131 views1 answer
Check if has alpha characters sql
SQL