Subject | Re: [ib-support] Count and distinct |
---|---|
Author | Gerhardus Geldenhuis |
Post date | 2003-01-15T10:06:58Z |
Jason Chapman (JAC2) wrote:
What does the sql standard say of handling a scenario like this. For me
it would make sense to be able to do a count(distinct(x,y,z)). It would
be nice if FB could do it...
Groete
Gerhardus
> Hi Ann,It would I think.
> Row 1:
> x = 'ABC'
> y = 'DEF'
> Row 2:
> x= 'ABCDE'
> y= 'F'
>
> Would break that wouldn't it.
>
What does the sql standard say of handling a scenario like this. For me
it would make sense to be able to do a count(distinct(x,y,z)). It would
be nice if FB could do it...
Groete
Gerhardus