Hi all,

I am having difficulties with resolving the following situation. I have a table as below:

client_id firstname lastname

ab11111 john doe
as11111 john doe
cl22222 jackie smith
pa22222 jackie smith
ct33333 john smith
ah33333 john smith
as55555 robert moore
ab55555 robert moore
ah66666 gkj kljlk
ct66666 gkj kljlk

I need to create an output which will show the duplicate records as below:

Client1 client2 ssn
ab as 11111
ab as 55555
cl pa 22222
ct ah 33333
ct ah 66666

How would I be able to do it??
It shouldn't show :

Client1 client2 ssn
ab as 11111
ab as 55555
cl pa 22222
ct ah 33333
ct ah 66666
as ab 11111
as ab 55555
ah ct 33333
ah ct 66666

Please help.....

Thanks.