Count of distinct values

[mkhadse]

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

 

[esearing]

TABLE FILE EMPLOYEE
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.