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 vote129 views1 answer
Python mysqlclient library not found for -lssl
SQL
1 vote143 views1 answer
Varchar plsql
SQL
0 vote127 views1 answer
Restore backup mysql .gz
SQL
0 vote173 views1 answer
Sql alter table add column if exists
SQL
8 votes134 views1 answer
Mysql limit rows
SQL
1 vote119 views3 answers
How to truncate foreign key constraint table
SQL
33 votes125 views6 answers
Change column name in mysql
SQL
19 votes131 views6 answers
Sql server drop table if exists
SQL
0 vote250 views1 answer
Generate a random otp in sql server
SQL
14 votes127 views5 answers
Set password for postgres user ubuntu
SQL