Karen Schaefer
asked on
Distinct count of Employees
Create a Distinct count of EmpIDs, where there are multiple rows with same EmpID.
What is the proper syntax?
What do I need to do to the above query to determine the correct count of EmpID's?
Thanks,
Karen
What is the proper syntax?
select DISTINCT COUNT(SCD.BEMSID)
, SCD.EMPID
, SCD.FULL_NAME
, SCD.DEPT
, SCD.EFF_FROM_DATE
, SCD.EFF_TO_DATE
, SCD.PEOPLE_CHANGE_DATE
, SCD.SCD_MANAGER_BEMSID
, SCD.MANAGER_BEMSID
FROM table1_v SCD
WHERE EFF_TO_DATE >= add_months(TRUNC(SYSDATE, 'YY'),-24)
AND ORG_STRUCTURE_CD LIKE '1SF%'
-- AND SCD.SCD_MANAGER_EMPID <> SCD.MANAGER_EMPID
-- AND EFF_TO_DATE >= add_months(TRUNC(SYSDATE, 'YY'),-24);
GROUP BY SCD.EMPID
, SCD.FULL_NAME
, SCD.DEPT
, SCD.EFF_FROM_DATE
, SCD.EFF_TO_DATE
, SCD.PEOPLE_CHANGE_DATE
, SCD.SCD_MANAGER_BMPID
, SCD.MANAGER_EMPID
ORDER BY SCD.FULL_NAME;
What do I need to do to the above query to determine the correct count of EmpID's?
Thanks,
Karen
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER