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 votes139 views2 answers
Add auto_increment column to existing table mysql
SQL
1 vote127 views1 answer
Mysql select row max date
SQL
0 vote138 views1 answer
Change magento database url usimg musql
SQL
0 vote134 views1 answer
Mysql milliseconds
SQL
0 vote137 views1 answer
Mysql set boolean default value
SQL
0 vote133 views1 answer
Oracle create table auto generated primary key
SQL
11 votes128 views3 answers
Sqlite3 create table from another table
SQL
7 votes128 views2 answers
What is sql clause
SQL
8 votes131 views1 answer
Oracle search source code
SQL
0 vote134 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL