Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cumulative variance in decrements for a column - Opposite of Cumulative sum

2909771Sep 20 2016 — edited Sep 21 2016

Hi,

Could you please help if there's a way to calculate Cumulative variance in SQL. I can easily calculate cumulative sum using 'SUM - OVER - PARTITION BY - ORDER BY' with clause of ROWS BETWEEN  UNBOUNDED PRECEDING AND  CURRENT ROW.

Would be nice to see how SQL compute the cumulative variance if the value has to go through decrements down the column.

Thanks.
This post has been answered by Vysakh Suresh - 3035408 on Sep 20 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2016
Added on Sep 20 2016
#sql
30 comments
3,228 views