Oracle select first row order by

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 vote146 views1 answer
Oracle temporary table
SQL
0 vote105 views2 answers
How to create a table from another table in sql derby
SQL
1 vote107 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote112 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote95 views1 answer
Mysql earlier than date
SQL
4 votes100 views1 answer
Find tables with column name in sql
SQL
3 votes115 views1 answer
Mysql replace string in table
SQL
12 votes121 views6 answers
How to install sqlite3 in python
SQL
1 vote101 views1 answer
Mysql select update same table
SQL
1 vote101 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL