Count of distinct values

mkhadse · Jul 26, 2001

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 · Jul 30, 2001

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.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Count of distinct values

mkhadse

Technical User

esearing

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor