[sqr-users] SQL question

["Vallabhu, Bindu" <Bindu.Vallabhu@Staples.com>]

Hi Everybody,
I have a table with the below data. I need to ignore the rows where the
PDT_DEPT_NUMBER is repeated. for example i need to ignore departments 23 and
29 in the below data. Can somebody please tell me how i can do this. This is
on a db2 database.
Thank you,
Bindu

PDT_DEPT_NUMBER                 CLASS_PDT_MNGR_NAME

---------------
--------------------------------------------------
             10                         000031 - Alan Basmajian

             11                         000011 - Kari Freeman

             12                         000011 - Kari Freeman

             13                         000082 - Jessica Urquhart

             14                         000011 - Kari Freeman

             15                         000031 - Alan Basmajian

             16                         000082 - Jessica Urquhart

             17                         000031 - Alan Basmajian

             18                         000082 - Jessica Urquhart

             19                         000011 - Kari Freeman

             20                         000031 - Chris DiOrio

             21                         000045 - Bob Simek

             22                         000038 - Leslie Seegel

             23                         000038 - Leslie Seegel

             23                         000039 - James Emond

             24                         000009 - Marc Golding

             25                         000042 - Betsy Matuzek

             26                         000042 - Betsy Matuzek

             27                         000042 - Betsy Matuzek

             28                         000045 - Bob Simek       
             29                         000032 - Jeff Scheman

             29                         000039 - James Emond

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users