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 vote177 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote177 views1 answer
Char vs varchar2 in sql
SQL
0 vote169 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
1 vote193 views1 answer
Oracle sql pad left zeros
SQL
0 vote160 views1 answer
Selects all the columns from the sailors table
SQL
7 votes197 views2 answers
Sql remove duplicates based on column
SQL
0 vote128 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
2 votes162 views3 answers
Postgres remove foreign key constraint
SQL
10 votes174 views2 answers
Rtrim sql
SQL
0 vote170 views1 answer
Sql not exists
SQL