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

3 votes194 views2 answers
Tsql join multiple record in one string
SQL
2 votes194 views2 answers
Postgresql search all tables for column name
SQL
0 vote347 views1 answer
Current month transactions in mysql
SQL
7 votes201 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote182 views1 answer
Mysql find missing values
SQL
0 vote192 views1 answer
Rollback to name in sql
SQL
0 vote201 views1 answer
Mysqli last row
SQL
0 vote180 views1 answer
Do postgresql
SQL
2 votes186 views1 answer
Set column to not null mysql
SQL
1 vote227 views1 answer
Create sqlite database in laravel
SQL