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 vote178 views1 answer
Mysql coonect sample code
SQL
42 votes266 views6 answers
Rename table sql server
SQL
0 vote179 views1 answer
Recover deleted data from mysql database
SQL
0 vote229 views1 answer
Postgressql uuid
SQL
0 vote176 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
12 votes173 views1 answer
Script to add new column in table sql
SQL
0 vote179 views1 answer
Oracle select partition
SQL
10 votes176 views1 answer
Oracle dba_dependencies
SQL
0 vote179 views1 answer
Mysql events not work
SQL
3 votes171 views4 answers
Show sql server database
SQL