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

17 votes108 views3 answers
Postgresql version command
SQL
9 votes125 views6 answers
Oracle substring
SQL
1 vote106 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote114 views1 answer
SQL server datetime compare
SQL
0 vote105 views1 answer
Create table as select sql server error
SQL
0 vote116 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote94 views1 answer
Search In the Data using ObjectName
SQL
0 vote121 views1 answer
DATEDIFF minute postgres
SQL
0 vote105 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
6 votes102 views1 answer
SQL insert all columns
SQL