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 vote266 views1 answer
Provera dupliranih konatakata
SQL
23 votes324 views5 answers
Sql substring
SQL
0 vote294 views1 answer
Mysql set variable to today's date
SQL
1 vote279 views2 answers
Limit sqlserver
SQL
2 votes313 views1 answer
Mysql id of inserted row
SQL
2 votes272 views2 answers
Exec procedure pl sql
SQL
2 votes319 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote293 views4 answers
How to connect form to database
SQL
13 votes271 views2 answers
Sqlite rename column
SQL
24 votes331 views6 answers
Sql change table name
SQL