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

1 vote165 views1 answer
SQL query to get all table records count from a database
SQL
0 vote230 views1 answer
Bash block size ls /var/lib/mysql
SQL
10 votes204 views4 answers
Else if mysql
SQL
0 vote163 views1 answer
Sql roll up rows into columns
SQL
0 vote338 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
0 vote191 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote182 views1 answer
Except in sql alchemy
SQL
0 vote175 views1 answer
Narural join
SQL
0 vote161 views1 answer
Power query case when
SQL
0 vote160 views1 answer
Get first name and last name from full name string in SQL
SQL