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

5 votes324 views2 answers
Oracle rename table
SQL
1 vote311 views1 answer
Crontab every month
SQL
0 vote295 views1 answer
Get number of table colums in sql query
SQL
0 vote355 views1 answer
Sql script to remove default from column
SQL
-1 vote400 views5 answers
Left join sql
SQL
0 vote312 views1 answer
Linked server delete openquery
SQL
0 vote308 views1 answer
Like and not like together in sql
SQL
0 vote350 views1 answer
Openquery update linked server
SQL
13 votes314 views2 answers
Check if value is null mysql
SQL
0 vote332 views1 answer
Sql string contains case sensitive
SQL