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 vote188 views1 answer
Sqldf change user
SQL
1 vote191 views3 answers
String to int mysql
SQL
1 vote198 views2 answers
Replace text in sql
SQL
0 vote239 views1 answer
Grouping by email domain mysql
SQL
25 votes216 views5 answers
Uninstall mysql ubuntu
SQL
2 votes196 views2 answers
Mysql user access to database
SQL
3 votes202 views1 answer
Oracle apex call duration
SQL
1 vote199 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
1 vote205 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
2 votes188 views2 answers
Oracle create table if not exists
SQL