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

1 vote170 views1 answer
How to change owner in postgres
SQL
5 votes174 views3 answers
Mysql extract month from date
SQL
2 votes206 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote169 views1 answer
Grant privileges of databse to user
SQL
0 vote168 views2 answers
Imageview setimageresource null
SQL
0 vote171 views1 answer
Sql sum if
SQL
1 vote166 views1 answer
Sql server find tables referenced foreign key
SQL
8 votes168 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote187 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
2 votes178 views1 answer
How to get weekday from old date in sql
SQL