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

19 votes210 views6 answers
Mysql if null
SQL
3 votes223 views2 answers
Truncate table
SQL
0 vote199 views1 answer
Sql row number in result set
SQL
1 vote219 views2 answers
Datetrunc hour snowflake
SQL
0 vote200 views1 answer
Is not null postgresql
SQL
0 vote259 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
1 vote197 views1 answer
Neo4j display all nodes and relationships
SQL
2 votes258 views3 answers
Row number mssql
SQL
0 vote212 views1 answer
Max mysql
SQL
6 votes231 views1 answer
T-sql test if table exists
SQL