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

6 votes235 views2 answers
If not exists insert sql
SQL
0 vote214 views1 answer
How to save data in database in mysql node
SQL
-1 vote246 views1 answer
Phinehas Psalm 106
SQL
0 vote232 views1 answer
How to execute stored output to csv files
SQL
0 vote247 views1 answer
Change date format in oracle query
SQL
10 votes180 views2 answers
Django mysql
SQL
21 votes234 views5 answers
Oracle all tables
SQL
0 vote251 views1 answer
What is delimiter in mysql
SQL
1 vote218 views1 answer
How to open closed port mysql in ubuntu
SQL
1 vote226 views2 answers
Rebuild index sql server
SQL