Subject | Count and distinct |
---|---|
Author | Gerhardus Geldenhuis |
Post date | 2003-01-13T13:24:14Z |
Hi
I have done a count(distinct(x)) with great success. The problem is now
that I want to do a count(distinct(x,y)). It does not work at all. I can
do a distinct x,y but not a combination of a multiple distinct and a
count. Is there any suggestion as to how to do this. I have experimented
a bit but can't find syntax that wants to work. At the moment I would
have to write a procedure to get the result which I think should not be
neccesary.
Groete
Gerhardus
I have done a count(distinct(x)) with great success. The problem is now
that I want to do a count(distinct(x,y)). It does not work at all. I can
do a distinct x,y but not a combination of a multiple distinct and a
count. Is there any suggestion as to how to do this. I have experimented
a bit but can't find syntax that wants to work. At the moment I would
have to write a procedure to get the result which I think should not be
neccesary.
Groete
Gerhardus