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

17 votes157 views3 answers
How to change a collumn name in sql
SQL
3 votes154 views1 answer
Oracle drop user
SQL
5 votes154 views3 answers
Truncate function in sql oracle
SQL
11 votes156 views3 answers
How to get last row of table in sql
SQL
0 vote156 views1 answer
Mysql workbench procedure
SQL
0 vote167 views1 answer
How to change mysql port in xampp
SQL
-1 vote152 views3 answers
Compute age mysql
SQL
3 votes148 views1 answer
Oracle list dates without weekends
SQL
0 vote148 views1 answer
Oracle remove line breaks
SQL
1 vote160 views1 answer
Psql import backup file for windows
SQL