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 vote204 views1 answer
Get date ISO in psql
SQL
0 vote191 views1 answer
Sql query to select records entered in last 24 hours
SQL
1 vote176 views10 answers
Stack overflow
SQL
0 vote191 views1 answer
Sql get guid
SQL
0 vote187 views1 answer
Sql drop default
SQL
1 vote205 views1 answer
Flask sqlalchemy default value
SQL
1 vote181 views1 answer
Postgres get timestamp
SQL
3 votes201 views1 answer
Oracle sleep
SQL
5 votes175 views1 answer
Mysql select greater than yesterday
SQL
1 vote201 views1 answer
Sql server insert into temp table
SQL