Answers for "sql query to get last one year data in oracle"

SQL
0

current year sql oracle

SELECT extract(YEAR FROM sysdate) FROM dual;			// number
SELECT to_char(sysdate, 'YYYY') FROM dual;				// varchar
Posted by: Guest on May-04-2021
-1

sql oracle take only last results

select * from table_name ORDER BY primary_id DESC FETCH FIRST 1 ROWS ONLY;
Posted by: Guest on July-28-2021

Code answers related to "sql query to get last one year data in oracle"

Code answers related to "SQL"

Browse Popular Code Answers by Language