How To Return Rows with Duplicate Values?

dvdaddict32 · #1 (**permalink**) 01-07-11, 17:07

I am fairly new to DB2, and can't figure out how to return a result set that shows me people with duplicate values in certain fields.

For example, my table has two differnet SSN fields

recip_ssn mbr_ssn

11223344 234558899
11223344 234558899

I want to see people who have two mbr_ssns in the table that are the same value. If I try count(mbr_ssn) > 1, it may return people with different mbr_ssn numbers.

Can anyone help?

r937 · #2 (**permalink**) 01-07-11, 17:58

i'm not sure i understand your question

Code:

SELECT recip_ssn 
     , mbr_ssn
  FROM daTable
GROUP
    BY recip_ssn 
     , mbr_ssn
HAVING COUNT(*) > 1

Internet Services

Web Development

Digital Marketing

Consumer Tech