Re: How to do this query?

SELECT C, B
FROM A
WHERE A IN (SELECT C

            FROM A
            GROUP BY C
            HAVING COUNT (C) > 1);

James Richard (JRICHARD_at_TUNS.CA)
"No Assembler Required!"

In article <0098F132.BC764E1C_at_vms.csd.mu.edu> 5603liul_at_vms.csd.mu.edu writes:
>Dear netters:
>
> I wonder how I can do this query?
>
> Assume I have a table, say A. In A, there are two columes,
>Say, B, C. Let's assmue it looks like this.
> B C
> --- ---
> 1 2
> 2 3
> 3 3
> 4 6
>
> How can we find the columns with duplicate C's? Here,
>it is (2,3) and (3,3).
>
> Thanks.
>
>
> David
Received on Fri Apr 21 1995 - 00:00:00 CEST