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 vote189 views1 answer
Oracle gather table statistics
SQL
0 vote197 views1 answer
Sql remove last 2 digit
SQL
0 vote230 views1 answer
Mysql concatenate select results
SQL
2 votes191 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
1 vote238 views1 answer
Wherein mysql
SQL
2 votes219 views2 answers
Mysql does sentence contain word
SQL
0 vote213 views1 answer
Nuget sqllite-net-pcl
SQL
0 vote193 views1 answer
Mysql bash execute sql file
SQL
4 votes149 views2 answers
Create table if not exists postgres
SQL
1 vote173 views1 answer
Select from one table where not on the other
SQL