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!

how to find percentage females in different job and age interval

705845Jul 8 2009 — edited Jul 8 2009
Hi frnds
How can we find percentage for example
i have following table
I want to find the Percentage of All Females who working as Clerk for different Jobs and different Age intervals
like 20 to 30 and 31 to 40 and 41 and above

emp
empno---------Job-------Gender---------Age
110------------Clerk---------M---------------20
112-------------Officer-------M------------35
111-------------clerk---------F------------21
113-------------Officer-------f------------32
114-------------Clerk---------M------------24
115--------------Clerk-------F--------------22

rgds
radhika
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 5 2009
Added on Jul 8 2009
3 comments
289 views