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

0 vote157 views1 answer
Get the next column of a table in mysql
SQL
0 vote139 views1 answer
Edit a field mysql terminal
SQL
0 vote151 views1 answer
How to set all the min and sec data to zero in sql server
SQL
2 votes174 views2 answers
Convert_tz mysql
SQL
1 vote161 views1 answer
Postgresql can you have null foreign key
SQL
0 vote189 views1 answer
Drop domain postgresql
SQL
0 vote149 views1 answer
Postgres drop type
SQL
0 vote223 views1 answer
Mysql disable triggers
SQL
0 vote161 views1 answer
Casterar postgres
SQL
-1 vote106 views1 answer
Mysql how to set update or create
SQL