PHIL Sawyer
asked on
using RECURSIVE WITH statement - using oracle 11g
Hello
Another question similar to one posted earlier today - angelIII helped me out earlier but this one is slightly different and best explained by seeing the attached - see cell C108 as for the required answer.
I have a table with 2 columns date and amount - again see attached for required outcome.
Regards
recursive2.xls
Another question similar to one posted earlier today - angelIII helped me out earlier but this one is slightly different and best explained by seeing the attached - see cell C108 as for the required answer.
I have a table with 2 columns date and amount - again see attached for required outcome.
Regards
recursive2.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
Not sure but I'm thinking that, in order to match your spreadsheet line for line the join should be on add_months(p.date,-1) = add_months(t.date,-12)
ASKER
This one works if I change t.date, -11 to
t.date, -12
Many thanks again