Re: Another Query Problem

Can you let me know if you get an answer - I have the same issue.

Thanks!

Regards,

• Scott

Ted Wasserman wrote:

> Thanks to anyone who can help with this one:
>
> I have a table with 3 Columns, X,Y,Z (each of those columns consists of
> the same datatype, with repeating values in each column and across the
> columns - in this case it is character strings such as 'a1', 'j5', 'k8'.
> So the table would look something like this:
>
> X | Y | Z
> -------------------
> 'a1' | 'b1' | 'c1'
> 'c1' | 'd5' | 'j9'
> 'f2' | 'a1' | 'c1'
>
> etc.
> Another table also exists listing all the character strings that may be
> used.
>
> I want a query that will return a list of (unique) character strings, if
> they appeared in any of the columns 3 or more times (+ the # of times
> they appeared overall in those columns)
>
> ie.
>
> CHARSTRING | #timesappeared
> -------------------
> 'a1' | 2
> 'b1' | 1
> 'c1' | 3
>
> etc....
>
> Good Luck!
>
> -TW
Received on Tue Nov 28 2000 - 17:55:12 CST