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

6 votes239 views1 answer
Wordpress change user password sql
SQL
0 vote227 views1 answer
Renommer table sql
SQL
3 votes265 views2 answers
Oracle sql first day of month
SQL
2 votes236 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote241 views1 answer
View to table
SQL
1 vote237 views1 answer
Sql run multiple updates in one query
SQL
0 vote245 views1 answer
Ver usuarios mysql
SQL
0 vote243 views1 answer
Create tables from xsd to sql server database c#
SQL
5 votes249 views2 answers
Create function postgresql
SQL
11 votes256 views2 answers
Oracle saurce code
SQL