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 vote145 views1 answer
Mysql command line ubuntu
SQL
0 vote146 views2 answers
Sql count number of rows after group by
SQL
2 votes148 views1 answer
Oracle sql concatenate results into string
SQL
0 vote145 views1 answer
Call scalar valued function sql
SQL
5 votes145 views1 answer
Postgres integer to serial
SQL
0 vote149 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote162 views1 answer
Less than and between in sql query
SQL
-1 vote145 views1 answer
Add column alter table default value
SQL
0 vote175 views1 answer
Repeatable read trong sql server
SQL
2 votes212 views3 answers
3 days back in sql server
SQL