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

11 votes340 views5 answers
Sql server reset identity
SQL
3 votes336 views1 answer
Force using index plsql
SQL
0 vote333 views2 answers
Mysql unique two columns
SQL
0 vote322 views1 answer
Composit key in sql
SQL
0 vote352 views1 answer
Insert data from stored procedure into table
SQL
1 vote361 views1 answer
Altrer name column postgres
SQL
11 votes318 views2 answers
MySQL DISTINCT
SQL
4 votes334 views4 answers
Print pl sql
SQL
0 vote371 views1 answer
Mysql date equals to current_date plus days
SQL
1 vote353 views1 answer
Oracle compile schema
SQL