Home » SQL & PL/SQL » SQL & PL/SQL » Run Oracle SQL query multiple times with change in filter condition (12c)
Run Oracle SQL query multiple times with change in filter condition [message #678424] Mon, 02 December 2019 05:20 Go to previous message
vsaenath
Messages: 3
Registered: December 2019
Junior Member
Select 201905,sum(s.amount)
From sales s
Where greatest(s.effectivedate,s.entrydate)<=20190530 --last day of each month
Group by s.level1;
Can some one let me know the best way to run above query for last 12 months from current month.
S.effectivedate and s.entrydate are numbers.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Want to know insert into
Next Topic: In SEND EMAIL code, how to remove Boundaries from the output
Goto Forum:
  


Current Time: Mon Dec 09 21:06:20 CST 2019