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

22 votes226 views4 answers
Mysql reset auto increment id
SQL
0 vote246 views1 answer
SQLServerException.makeFromDatabaseError
SQL
9 votes237 views6 answers
Oracle substring
SQL
4 votes252 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
2 votes219 views2 answers
Mysql user access to database
SQL
3 votes229 views1 answer
Postgres count distinct
SQL
4 votes248 views1 answer
Rename stored procedure in sql server
SQL
0 vote218 views1 answer
Create table in dbms cmds
SQL
1 vote252 views1 answer
Backup mysql schema only
SQL
0 vote252 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL