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

0 vote210 views1 answer
Systemverilog unique constraint unique values
SQL
3 votes257 views2 answers
Truncate table
SQL
0 vote224 views1 answer
Update database collation in postgresql
SQL
0 vote223 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote220 views1 answer
Mysql locate
SQL
0 vote204 views1 answer
Reading from right to left from string find first special characters in sql
SQL
1 vote214 views1 answer
Sql auto date
SQL
1 vote216 views1 answer
Oracle create_program
SQL
0 vote280 views1 answer
Mysql get longest string in column
SQL
1 vote232 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL