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!

how to calculate cumulative percentages?

user497841Apr 17 2011 — edited Apr 17 2011
i have a query to get month to date data

select site,pmonth,sum(a)/sum(b)*100 as MTD
from
mytable
group by site,pmonth

Need help calculating year to date percentage..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 15 2011
Added on Apr 17 2011
3 comments
421 views