I do
select count (distinct(x || '//' || y) from <table>

----- Original Message -----
From: Gerhardus Geldenhuis
To: ib-support@yahoogroups.com
Sent: Wednesday, January 15, 2003 11:06 AM
Subject: Re: [ib-support] Count and distinct


Jason Chapman (JAC2) wrote:
> Hi Ann,
> Row 1:
> x = 'ABC'
> y = 'DEF'
> Row 2:
> x= 'ABCDE'
> y= 'F'
>
> Would break that wouldn't it.
>

It would I think.

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


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]