Oracle select first row order by

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

6 votes172 views1 answer
Oracle trigger after logon on database
SQL
0 vote224 views1 answer
Create a plsql object
SQL
0 vote170 views1 answer
Increment id in mysql
SQL
19 votes225 views5 answers
Display table in sql
SQL
5 votes202 views2 answers
Oracle list columns
SQL
0 vote223 views1 answer
Take sql dump in to file
SQL
0 vote212 views2 answers
How to combine two sql queries in one result
SQL
1 vote188 views1 answer
Add many column to sap iq table
SQL
16 votes176 views2 answers
Gremove folder from git
SQL
0 vote143 views0 answer
SQL