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 vote328 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote305 views1 answer
Sql query for getting data with join and count
SQL
0 vote319 views1 answer
Insert array into mysql column
SQL
6 votes325 views2 answers
Oracle
SQL
4 votes314 views1 answer
Mysql set max connections
SQL
0 vote316 views1 answer
Datagrip exec
SQL
2 votes331 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote344 views1 answer
Sql date time query find
SQL
0 vote342 views1 answer
Alter boolean column postgresql
SQL
0 vote338 views1 answer
Sql order by except one row
SQL