hi
i am using 10g
i would like to calculate monthly average bal from the given data for the period 01-apr-2009 to 31-mar-2010
create table tx
(branch number(6),acno number(8),balanceDate date,balance number (13,2));
--======
insert into tx values (16,1,to_date('15-mar-09','dd-mon-yyyy'),15000)
insert into tx values (16,1,to_date('11-OCT-09','dd-mon-yyyy'),5000)
insert into tx values (16,1,to_date('01-jan-10','dd-mon-yyyy'),11000)
insert into tx values (16,1,to_date('03-mar-10','dd-mon-yyyy'),11093)
insert into tx values (16,1,to_date('20-mar-10','dd-mon-yyyy'),11090.79)
expected result is
branch acno month-year averageBalance
i could able to calculate daily average but not able to calculate montly average particularly for missing months in a given period......please help