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 vote270 views1 answer
Get only first row mysql
SQL
6 votes293 views1 answer
How to count number of rows in sql
SQL
12 votes308 views4 answers
Mysql get date difference in hours
SQL
0 vote308 views1 answer
How many rows affected in sqllite
SQL
0 vote356 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
1 vote296 views1 answer
Oracle db create new schema
SQL
3 votes310 views2 answers
Find the median in sql
SQL
0 vote288 views1 answer
Time in sql server
SQL
11 votes311 views3 answers
Change column name sql server management studio
SQL
1 vote337 views1 answer
Insert many to many sql
SQL