At 03:24 PM 1/13/2003 +0200, Gerhardus Geldenhuis wrote:

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

Try
select count (distinct (x || y)) from <table>


Regards,

Ann
www.ibphoenix.com
We have answers.