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

7 votes185 views2 answers
Phpmyadmin change password
SQL
1 vote152 views1 answer
Mysql check table exists
SQL
0 vote149 views2 answers
Update all linkedserver tables with openquery on db
SQL
0 vote190 views1 answer
ALV GRID events
SQL
0 vote160 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote147 views1 answer
Mql5 list all available symbols
SQL
0 vote156 views1 answer
Dbms_output sql developer
SQL
0 vote194 views1 answer
Google sheets data validation custom formula filter
SQL
6 votes206 views3 answers
Mysql change auto_increment start value
SQL
3 votes189 views4 answers
Mysql create table from select statement
SQL