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 vote334 views1 answer
Concat column value of same user in mysql
SQL
3 votes328 views1 answer
Oracle limit user tablespace
SQL
0 vote357 views3 answers
Sql drop all tables
SQL
9 votes345 views1 answer
Sql server get utc date
SQL
10 votes322 views2 answers
Django mysql
SQL
3 votes332 views3 answers
Mysqldump: couldn
SQL
11 votes786 views4 answers
Reset identity column values in sql server
SQL
3 votes342 views4 answers
Mysql decimal
SQL
0 vote337 views1 answer
Sql select first and last record of each group
SQL
1 vote354 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL