Re: Analitics help please....

Will this work? select b.id , trunc(b.today) tday , b.code , b.value , sum(B.VALUE) over (partition by b.id, trunc(b.today), b.code order by b.id, trunc(b.today), B.CODE range between unbounded preceding and CURRENT ROW) val_total from ( select id, trunc(today) today, code,

Analitics help please....

I need some help with some SQL pleeeaasseee I'm trying to do some summay work with some data using some of the Oracle9i Analytic functions. Here is the sample data: SQL> select * from sum_test; ID TODAY CODE VALUE -- -