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 vote372 views1 answer
How to list function in psql
SQL
0 vote358 views1 answer
Sql count null values in all columns
SQL
7 votes341 views3 answers
Sql get last inserted row
SQL
0 vote361 views1 answer
Alter column to not null with default value sql server
SQL
1 vote304 views2 answers
Show sql logs in spring boot
SQL
0 vote343 views2 answers
Sql use not in
SQL
0 vote345 views1 answer
Inser into example
SQL
0 vote372 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote373 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote353 views1 answer
Show database not empty tables postgres
SQL