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 vote209 views1 answer
Sqlite3 read only
SQL
0 vote228 views1 answer
What is logical database schema
SQL
0 vote192 views1 answer
Raiserror nowait sql server
SQL
0 vote255 views1 answer
Select count concat string sql server
SQL
1 vote227 views1 answer
Mysql search like order by best match
SQL
5 votes238 views2 answers
Oracle show procedures
SQL
0 vote190 views1 answer
Check if record exists mysql
SQL
22 votes207 views4 answers
Mysql date_format
SQL
0 vote211 views3 answers
Delete in SQL SERVER
SQL
0 vote219 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL