Archives of the TeradataForum
Message Posted: Wed, 25 Sep 2002 @ 13:27:04 GMT
| Subj: || || Re: Count(case... to get a count(distinct acct_id) Is this possible? |
| From: || || Burton, Bruce |
Thanks John. SAS allows me to use multiple count(distinct's on a query. I was having a problem on my queryman query because I had two
count(distinct's on the same query with slightly different case logic (the date in the case was '<' rather than '>='). I changed my sql to
do multiple queries with a union all to combine.