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!

Report on percentage metrics with SQL

514497Aug 27 2009 — edited Nov 3 2010

Hi All,

We have a requirement to create a report on few metrics.

Example

ORG COST_BY_ORG PERCENTAGE

FA1 total 100 14.29%
HG total 400 57.14%
JY total 200 28.57%

grand total: 700 100%

I was able to acheive till the totals by ORG. But not sure how I could include the percentage with in the same query.

Any ideas please!

Thanks,
Prathima

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2009

Added on Aug 27 2009

17 comments

8,777 views