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 vote50 views1 answer
Hex string sql becomes int64
SQL
4 votes45 views1 answer
Mysql copy table with new name
SQL
0 vote39 views1 answer
Update having mysql
SQL
3 votes43 views2 answers
Truncate table
SQL
0 vote3 views1 answer
Select mysql limit to 2 decimal places
SQL
0 vote49 views1 answer
Changer un mot de passe mysql
SQL
2 votes46 views1 answer
Mysql add boolean column
SQL
3 votes49 views3 answers
Mysql get table size
SQL
0 vote49 views1 answer
Describe in sqlite3
SQL
0 vote48 views1 answer
Last date for each user sql
SQL