Re: Very Simple SQL question ... hepl ? ...

From: Anon <pjbump_at_i1.net>
Date: 1997/09/20
Message-ID: <01bcc5e8$e8e46ce0$d33ae6cf_at_default>#1/1


SELECT A.last_name, A.pid
  FROM tablex A, tablex B
 WHERE A.last_name = B.last_name
   and A.rowid <> B.rowid;

-- 
Phillip Bump
Senior Principal Consultant
Oracle Consulting
----------------------------------------------------------------------------
-----------------------------------------------------------------------
[Quoted] The opinions expressed are my own and do not necessarily reflect those of
Oracle Corporation

Hank Griffioen <hank_at_daac.gsfc.nasa.gov> wrote in article
<34201C6E.CF4C987B_at_daac.gsfc.nasa.gov>...

> I have a table called names that has last_name and pid in
> the table. I am tryint to find a simple query that
> will all me to select all rows that have duplicated last names.
>
> For example
>
> last_name pid
> --------------------------
> smith 1
> smith 3
> jones 4
> griffin 5
> stevens 6
> stevens 7
>
> I want to do the opposite of distinct.
>
> something like ....
> select duplicate last_name pid from person.
>
> smith 1
> smith 3
> stevens 6
> stevens 7
>
>
> --
> Hank Griffioen CFII,MEII,AGI,IGI INTERNET:
> hank_at_daacdev1.nasa.gsfc.gov
> GSFC BLD 32 Code 902.2 fax 614-5304
> Greenbelt, MD 20770 Phone: 301-614-5488
> To order CD-ROMs and data URL = http://daac.gsfc.nasa.gov/
> NASA Goddard Flying Club URL = http://daac.gsfc.nasa.gov/NGFC/
> (***I do not speak for HSTX, NASA or NASA Goddard Flying Club***)
>
Received on Sat Sep 20 1997 - 00:00:00 CEST

Original text of this message