Skip to Main Content

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2009
Added on Aug 27 2009
17 comments
8,772 views