Very Simple SQL question ... hepl ? ...

[Quoted] [Quoted] I have a table called names that has last_name and pid in [Quoted] [Quoted]   the table. I am tryint to find a simple query that [Quoted] [Quoted]   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***)