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


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

Original text of this message