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

1 vote334 views2 answers
Sql convert datetime to year month
SQL
0 vote354 views1 answer
Select even number id data from table
SQL
0 vote421 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote375 views2 answers
Mysql update two tables at once
SQL
1 vote303 views1 answer
Postgres grant read only access to database
SQL
0 vote349 views1 answer
Mysql date time string format python
SQL
0 vote328 views1 answer
Vbscript create ADODB.Connection
SQL
4 votes391 views1 answer
Sql delete multiple conditions
SQL
28 votes350 views4 answers
Show tables mysql
SQL
0 vote341 views1 answer
Get last updated row sql server
SQL