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 vote334 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote379 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote342 views1 answer
With_for_update sqlalchemy
SQL
1 vote334 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote359 views1 answer
Psql store procedure-return multiple table values
SQL
3 votes277 views2 answers
Mysql sum with condition
SQL
5 votes350 views2 answers
Postgresql add not null constraint
SQL
4 votes307 views2 answers
Oracle set date format
SQL
5 votes336 views2 answers
Postgre insert select
SQL
0 vote337 views1 answer
Connexion mysql
SQL