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

10 votes170 views2 answers
Sql merge statement
SQL
0 vote174 views1 answer
Sql date between one week
SQL
5 votes166 views1 answer
Oracle list packages
SQL
0 vote172 views2 answers
How to start postgresql laravel
SQL
0 vote195 views1 answer
Trigger stock phpmyadmin
SQL
31 votes181 views2 answers
Grant all priviledges to mysql user
SQL
1 vote161 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote175 views1 answer
Sql make sure every user is unqiuew
SQL
1 vote176 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote163 views1 answer
Where case insensitive like mysql
SQL