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 vote146 views1 answer
Sql server update top n records
SQL
0 vote157 views1 answer
Select amount weeks between two dates mysql
SQL
7 votes162 views3 answers
Sql server reset auto increment
SQL
0 vote180 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote186 views2 answers
How to install psql in ubuntu
SQL
0 vote168 views1 answer
Get only structure database mysql
SQL
27 votes146 views5 answers
Add column in table
SQL
0 vote145 views1 answer
Find invalid datetime field
SQL
-1 vote140 views1 answer
Search all database tables for a value sqlserver
SQL
0 vote144 views1 answer
How many columns can be used for creating index?
SQL