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 vote328 views1 answer
C# execute transact sql
SQL
0 vote309 views1 answer
Install squirrel sql ubuntu
SQL
15 votes302 views2 answers
Select Options
SQL
0 vote317 views1 answer
Sql check if column exists
SQL
0 vote335 views1 answer
Mariadb create index if not exists
SQL
0 vote252 views1 answer
Import sql file in mysql linux
SQL
0 vote297 views1 answer
View to table
SQL
1 vote310 views1 answer
Snowflake rename column name
SQL
5 votes307 views3 answers
Select tables from mysql database
SQL
2 votes314 views1 answer
Mysql clear screen
SQL