Sql first

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 vote173 views1 answer
Last 6 months postgresql
SQL
10 votes203 views2 answers
Sql pagination offset
SQL
0 vote176 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote173 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
8 votes171 views1 answer
Alter tablespace add datafile
SQL
0 vote181 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote185 views1 answer
Postgress append string in select
SQL
0 vote207 views1 answer
"Hello User Name"
SQL
6 votes176 views1 answer
Phpmyadmin password root
SQL
0 vote184 views1 answer
Oracle select partition
SQL