Oracle select first result

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 vote254 views1 answer
Mysql history command
SQL
0 vote259 views1 answer
How to check even or odd in sql
SQL
12 votes284 views2 answers
Insert multiple rows from another table sql
SQL
0 vote263 views1 answer
Recover deleted data from mysql database
SQL
4 votes274 views4 answers
Oracle tablespace tables list
SQL
0 vote265 views1 answer
Create database store
SQL
0 vote256 views1 answer
Sql select first and last record of each group
SQL
0 vote277 views1 answer
Change permission to database mysql
SQL
0 vote280 views1 answer
Exit psql
SQL
0 vote274 views1 answer
Sql get year from datetime field
SQL