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

2 votes364 views2 answers
Mysql user access to database
SQL
0 vote335 views1 answer
Alter session set nls_language french
SQL
0 vote350 views1 answer
Import sql dump into postgresql database
SQL
0 vote346 views1 answer
List MySQL Table and Index Size
SQL
1 vote399 views1 answer
Login to database mysql terminal
SQL
0 vote409 views1 answer
Write SQL in ruby on rails
SQL
11 votes396 views2 answers
Oracle saurce code
SQL
15 votes387 views4 answers
Mysql export database command line
SQL
0 vote345 views1 answer
Mysql into outfile with headers
SQL
3 votes423 views1 answer
Oracle sql commit example
SQL