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

1 vote139 views1 answer
Sql select where id not exists in another table
SQL
3 votes136 views1 answer
Oracle list dates without weekends
SQL
0 vote133 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote139 views1 answer
Mysql max number not returning correct value
SQL
0 vote152 views1 answer
Postgresql import a database of gzip
SQL
2 votes136 views1 answer
Q operator in plsql
SQL
9 votes155 views4 answers
Oracle get table column names
SQL
4 votes138 views3 answers
How to describe a table in sqlite3
SQL
0 vote132 views1 answer
T-SQL Never ending DELETE
SQL
2 votes148 views1 answer
Add new column not null sql server
SQL