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