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

1 vote159 views1 answer
Oracle select first row order by
SQL
1 vote144 views1 answer
Set statiscis on in sql server
SQL
5 votes131 views2 answers
Sql create tabel with primary key auto_increment code
SQL
0 vote95 views1 answer
Update set with join pl sql
SQL
0 vote88 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote123 views1 answer
How to stop all connections to a psql 12 database?
SQL
2 votes125 views1 answer
Update with join sql server
SQL
0 vote132 views1 answer
Sql create table with references not primary key
SQL
0 vote131 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
0 vote138 views2 answers
Oracle chain rules
SQL