Count of distinct values
Count of distinct values
(OP)
How can I count the number of distinct values in a TABLE.
TABLE EMPLOYEE
COUNT CITY
BY DEPARTMENT.
I want to list the number of distint cities the employees are staying in for every Department.
Please help me with this, I have gone through the documentatin but did not find any suitable command.
Thanks
TABLE EMPLOYEE
COUNT CITY
BY DEPARTMENT.
I want to list the number of distint cities the employees are staying in for every Department.
Please help me with this, I have gone through the documentatin but did not find any suitable command.
Thanks
RE: Count of distinct values
SUM CNT.DST.CITY
BY DEPARTMENT
END
Eric
Starting GA/AL Focus User Group (FUSE) in Atlanta. See IBI website for usergroup info or contact me at eric.searing@wcom.com.