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 vote117 views1 answer
Get sum sqlite android
SQL
3 votes195 views1 answer
Sql add two values together
SQL
3 votes122 views4 answers
Ubuntu stop mysql
SQL
1 vote122 views4 answers
Fatal database postgres does not exist
SQL
0 vote158 views1 answer
Mysql bind-address default value
SQL
0 vote124 views1 answer
Postgres can integer fields be negative
SQL
2 votes132 views2 answers
Insert all in sql
SQL
1 vote139 views1 answer
Postgres format date in select
SQL
1 vote118 views1 answer
Mysql check if string contains comma separated
SQL
0 vote141 views1 answer
Add mysql database to power bi web
SQL