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 vote163 views1 answer
Sql roll up rows into columns
SQL
0 vote163 views1 answer
Sqlite update only if greater
SQL
3 votes169 views1 answer
Fk in insert mysql
SQL
0 vote190 views1 answer
Virtuoso sql query tutorial
SQL
0 vote165 views1 answer
Mysql match in serialized data
SQL
1 vote257 views1 answer
SQL server query column yes or no
SQL
0 vote172 views1 answer
Sql list dates between two dates
SQL
0 vote157 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote130 views1 answer
Java spring jdbc connect to postgresql
SQL
0 vote161 views1 answer
Sql check for null and empty string
SQL