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 vote178 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote164 views1 answer
Oracle free up space in tablespace
SQL
0 vote263 views1 answer
Mysql equivalent decode oracle
SQL
0 vote180 views1 answer
Create domain sql
SQL
10 votes142 views2 answers
Sql where clause multiple values
SQL
12 votes183 views4 answers
How to check mysql version ubuntu
SQL
5 votes178 views1 answer
Sql check if date is between 2 dates
SQL
0 vote186 views1 answer
Insert or update sql firebird
SQL
2 votes175 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote176 views1 answer
Postgres statistics
SQL