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 vote201 views1 answer
Multiple left join mysql
SQL
0 vote222 views1 answer
Oracle list datafiles
SQL
4 votes214 views2 answers
Tables in sql
SQL
3 votes224 views2 answers
Sql not contains
SQL
1 vote192 views2 answers
Sql for date greater than
SQL
1 vote220 views1 answer
Postgres left join
SQL
2 votes205 views2 answers
Postgres add column integer
SQL
23 votes203 views3 answers
Sql where contains part of string
SQL
5 votes310 views1 answer
Oracle asynchronous procedure
SQL
0 vote193 views2 answers
Mysql output csv
SQL