Sql first

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

20 votes185 views4 answers
Sqlite create table if not exists
SQL
0 vote172 views1 answer
Sql server python connection
SQL
1 vote233 views1 answer
OSError: mysql_config not found
SQL
0 vote144 views1 answer
Oracle sysdba connect as another user
SQL
0 vote173 views1 answer
T-sql conditional order by multiple columns
SQL
0 vote214 views1 answer
In query in sql
SQL
3 votes193 views2 answers
Oracle apex charging debug
SQL
0 vote182 views1 answer
How to use lower case in mysql
SQL
0 vote184 views1 answer
Get who is hired in specific month in sql
SQL
1 vote225 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL