Re: How to do this query?
From: Saad Ahmad <sahmad_at_mfa.com>
Date: 1995/04/19
Message-ID: <3n239h$8ft_at_homer.alpha.net>#1/1
Date: 1995/04/19
Message-ID: <3n239h$8ft_at_homer.alpha.net>#1/1
5603liul_at_vms.csd.mu.edu wrote:
> 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).
select a.b, a.c
from a
where exists ( select 'x'
from a a1 where a1.c = a.c and a1.rowid != a.rowid )
-- ************************************************************** * Saad Ahmad * * McHugh Freeman & Associates, Inc. * * Ph: (414) 798-8606 Ext. 457 * * Fax: (414) 798-8619 * * E-Mail: sahmad_at_mfa.com * **************************************************************Received on Wed Apr 19 1995 - 00:00:00 CEST