Re: Another Query Problem

Not sure if I fully understood the question but try this

select tab1.col1,count(tab1.col1)
from

    (select x col1
    from table1
    union all
    select y
    from table1
    union all
    select z from table1) tab1
group by col1
having count(tab1.col1) > 2

HTH Conan

sw_at_weinerfamily.org wrote in message <3A2445BB.D7BE4FF4_at_weinerfamily.org>...
>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 Wed Nov 29 2000 - 03:03:52 CST