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 vote220 views1 answer
Sql server count all tables rows
SQL
0 vote234 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote214 views1 answer
Postgresql in vs any performance
SQL
-1 vote242 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote211 views2 answers
Plsql function that return a table
SQL
-1 vote186 views1 answer
Plsql while
SQL
0 vote219 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
8 votes201 views3 answers
Mysql alter table add index
SQL
0 vote189 views1 answer
Oracle select invalid views
SQL
28 votes163 views6 answers
Distinct sql
SQL