Re: OCI Problem - HELP
From: Mike Androff <mja_at_idm.com>
Date: Tue, 15 Mar 1994 18:09:10 GMT
Message-ID: <CMpx3B.AwB_at_idm.com>
Date: Tue, 15 Mar 1994 18:09:10 GMT
Message-ID: <CMpx3B.AwB_at_idm.com>
Kevin Lukes (klukes_at_novatel.ca) wrote: : SELECT COUNT(DISTINCT NAME || DIVISION || TITLE) FROM COMPANY_TABLE; If you use this method, be sure to place some delimiter between the concatenated columns or you may be grouping what are really different distinct values. For instance, BILLY || SALES || MANAGER will give the same value as BILL || YSALE || SMANAGER (OK, stupid example, but you get the point :-) ). Use something like
SELECT COUNT(DISTINCT NAME || '!' || DIVISION || '!' || TITLE)... I ran across this problem recently and the results were way off until this little quicky fix.
Mike Androff mja_at_idm.com "Making the world a better place for me." 8-) Received on Tue Mar 15 1994 - 19:09:10 CET