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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing
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,710 views