Re: How to do this query?
From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/04/19
Message-ID: <3n3b34$5ab_at_ixnews4.ix.netcom.com>#1/1
Date: 1995/04/19
Message-ID: <3n3b34$5ab_at_ixnews4.ix.netcom.com>#1/1
>
>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
Try this...
select * from a
where c in (select c from a group by c having count(*) >
1);
><> Chuck Hamilton <><
Received on Wed Apr 19 1995 - 00:00:00 CEST