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 votes124 views2 answers
Mysql alter column default
SQL
0 vote121 views1 answer
Virtuoso sql query tutorial
SQL
2 votes130 views1 answer
Where clause for child record apex
SQL
0 vote129 views1 answer
Get statis values sql
SQL
3 votes115 views1 answer
Oracle limit user tablespace
SQL
7 votes114 views6 answers
Reset identity column in sql server
SQL
0 vote148 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote83 views2 answers
How to combine two sql queries in one result
SQL
0 vote108 views1 answer
Mysql create pool
SQL
0 vote126 views1 answer
Java sql insert return id
SQL