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

0 vote237 views1 answer
Check index sql server
SQL
0 vote265 views2 answers
Alter table add multiple columns mysql
SQL
3 votes250 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote248 views1 answer
Mysqlimport
SQL
0 vote259 views1 answer
Replace string in whole database mysql stackoverflow
SQL
1 vote252 views1 answer
Oracle apex prevent initial load
SQL
0 vote231 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote271 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
0 vote254 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
1 vote256 views2 answers
Drop table if exists test
SQL