1

Topic: How to make the rising total on product?

Product is considered in the normal mathematical image

SELECT EXP (SUM (LN (1+YIELD_FACT))) twr_fact
--select *
from rtr_yield

And how it in window - to thrust? I can not think.

2

Re: How to make the rising total on product?

exp (sum (...) over (order by...))

3

Re: How to make the rising total on product?

andrey_anonymous, it should be a shame with such questions, but itself for ever would not guess.
Thanks big, the colleague.

SELECT
--EXP (SUM (LN (1+YIELD_FACT))) twr_fact, EXP (SUM (LN (1+YIELD_N2))) twr_n2
y. *,
EXP (SUM (LN (1+YIELD_FACT)) over (order by yield_date)) twr_fact_running_total
--select *
from RTR_YIELD y