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

2 votes143 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote138 views1 answer
Mysql export and import
SQL
1 vote138 views1 answer
Store select query result in variable sql server
SQL
0 vote143 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
0 vote133 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
1 vote188 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote148 views1 answer
Sql dmv to capture updates
SQL
2 votes157 views1 answer
Use cases condition in sql query laravel
SQL
0 vote153 views2 answers
Sql max count
SQL
2 votes168 views2 answers
Postgres timestamp to datetime
SQL