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

13 votes129 views5 answers
Sql default
SQL
7 votes107 views1 answer
Forge server hosting
SQL
0 vote140 views1 answer
Time data type in mysql
SQL
24 votes118 views4 answers
Postgres delete database
SQL
4 votes124 views2 answers
Convert utc to est sql
SQL
0 vote105 views1 answer
Mysql money value
SQL
0 vote113 views1 answer
Mysql grant all on all databases
SQL
0 vote117 views1 answer
Returning with sqlalchemy
SQL
1 vote129 views1 answer
Sample clause in sql
SQL
0 vote131 views1 answer
How to find table lock and row lock in mysql
SQL