Archives of the TeradataForum
Message Posted: Tue, 24 Sep 2002 @ 19:02:12 GMT
| Subj: || || Re: Count(case... to get a count(distinct acct_id) Is this possible? |
| From: || || deWet, Johannes M |
I suspect the problem is not your count(distinct) SQL, it's the additional columns you're selecting after your count(distinct ....). Try
your count(distinct case..) on it's own (the way you have it coded should work). If you need to do something like SELECT count(distinct
columna),count(distinct columnb), I would suggest doing a subselect with a union etc.., or something similar...