Oracle select first result

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 vote201 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
25 votes198 views5 answers
Uninstall mysql ubuntu
SQL
0 vote214 views1 answer
Mysql select random rows large table
SQL
0 vote202 views1 answer
Sql select with apostrohpe
SQL
0 vote254 views1 answer
Selecting specific day in colum sql
SQL
0 vote153 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote183 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote185 views1 answer
Copy data from cell to cell mysql
SQL
0 vote195 views1 answer
Mysql coonect sample code
SQL
0 vote202 views1 answer
Postgres set default schema
SQL