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

3 votes184 views2 answers
Find the median in sql
SQL
0 vote196 views1 answer
Jdbc sql connection string
SQL
3 votes262 views1 answer
Oracle apex warn on unsaved changes
SQL
0 vote266 views1 answer
Migrations.RunSQL
SQL
3 votes192 views2 answers
Sql add year to date
SQL
0 vote211 views2 answers
Starts and end with vowel sql
SQL
14 votes196 views3 answers
Trim sql
SQL
1 vote193 views1 answer
What is in condition in sql
SQL
0 vote185 views1 answer
Mysql update sum same table
SQL
9 votes194 views4 answers
How to create new user and database postgresql in ubuntu
SQL