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!

Find average of count

637632Dec 8 2009 — edited Dec 8 2009

Hi,
How to find average of count ..something like AVG(count(*))

I have table employee_master where employee_id is the unique key. This table has one more field which is Department.
I want to find average employees/dept...

select department AVG(count(*)) from employee_master group by department

How can I achieve this..

Please help,
Regards,
Raja

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 5 2010

Added on Dec 8 2009

2 comments

5,653 views