At 1/13/2003 08:24 AM, Gerhardus wrote:

>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.

Perhaps count(distinct x || y) will provide the answer you are looking for?

hth,

Bob M..