Skip to Main Content

Analytics Software

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!

MANAGERS HAVING MORE THAN 2 EMPLOYEES IN A REPORT

2801196Dec 15 2014 — edited Jan 5 2015

Hi experts

I have one requirement.i have EMP table.I created self join in rpd by creating alias table of emp(manager).Now my requirement is i want one report that is managers having more than 2 employees list.i want result through rpd not from analytics.I developed the query in sql like below

SELECT Mgr,

COUNT(EMPno) EMP_COUNT

FROM EMP

GROUP BY Mgr HAVING (COUNT(EMPNO)>2

Result:

      mgr           emp_count

      7839          3

      7698          5

Thanks

Lucky

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details