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 vote297 views2 answers
Sqlite unix timestamp
SQL
0 vote300 views1 answer
Oracle temporary table
SQL
0 vote301 views1 answer
How change the field place in mysql
SQL
16 votes312 views3 answers
Update table from another table
SQL
1 vote334 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote311 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote296 views1 answer
Case when with count and combining similar values in sql
SQL
2 votes294 views1 answer
Get first n letter of department name in sql
SQL
1 vote282 views1 answer
Display total number of tables in mysql
SQL
0 vote353 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL