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 vote220 views1 answer
WHERE not regex in SQL
SQL
0 vote191 views2 answers
SQL FROM
SQL
0 vote199 views1 answer
Datagrip exec
SQL
10 votes218 views4 answers
Drop primary key
SQL
0 vote199 views1 answer
Sql insert from excel
SQL
0 vote200 views1 answer
Initcap in sql
SQL
1 vote210 views3 answers
Alter schema sql server
SQL
14 votes206 views2 answers
Oracle export trigger ddl
SQL
1 vote151 views1 answer
Postgres reset auto increment
SQL
0 vote205 views1 answer
Execute sql stored procedure in powershell
SQL