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 vote219 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote211 views1 answer
Empty table sqlite
SQL
0 vote215 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote206 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
2 votes225 views3 answers
Sql interview query questions
SQL
1 vote171 views1 answer
Database run
SQL
0 vote211 views1 answer
What is top n result in sql
SQL
0 vote207 views1 answer
Sql server datetime
SQL
0 vote204 views1 answer
Knex last insert id mysql
SQL
0 vote192 views1 answer
Show function mysql
SQL