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

3 votes268 views1 answer
How to check schema privileges in oracle
SQL
7 votes287 views2 answers
Html to react converter
SQL
0 vote280 views1 answer
Print intervals of 15 minutes in sql query
SQL
4 votes289 views4 answers
Date less than in sql
SQL
0 vote289 views1 answer
Sql change column in existing table
SQL
1 vote279 views4 answers
Alter schema sql
SQL
14 votes294 views3 answers
Inner join sql oracle
SQL
1 vote301 views1 answer
Sql first day quarter
SQL
7 votes271 views1 answer
Safe mode mysql
SQL
8 votes279 views1 answer
Show mysql user table
SQL