| Subject | Re: [ib-support] Count and distinct |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2003-01-13T16:46:06Z |
At 03:24 PM 1/13/2003 +0200, Gerhardus Geldenhuis wrote:
select count (distinct (x || y)) from <table>
Regards,
Ann
www.ibphoenix.com
We have answers.
>HiTry
>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.
select count (distinct (x || y)) from <table>
Regards,
Ann
www.ibphoenix.com
We have answers.