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 vote272 views1 answer
Sp in sql server
SQL
0 vote265 views1 answer
Postgres read table structure
SQL
0 vote255 views1 answer
Sql describe
SQL
1 vote269 views3 answers
Union SQL
SQL
6 votes247 views1 answer
Sqlite foreign key
SQL
0 vote262 views1 answer
How to use group_concat in sql server
SQL
0 vote259 views1 answer
Add column in sql server ubuntu
SQL
0 vote277 views1 answer
Repeatable read trong sql server
SQL
0 vote278 views1 answer
Sql delete caracter list
SQL
2 votes258 views3 answers
3 days back in sql server
SQL