How do I find out those duplicates using SQL

ap_mainframes · Posted: Wed Sep 17, 2008 8:21 am

Hi,

I have this requirement:
The DB2 tables looks like this
Feild A
Feild B
Feild C

In these feilds we have some duplicates.
How do I find out those duplicates. ?
Can this be done with an SQL ?

dick scherrer · Posted: Wed Sep 17, 2008 8:55 am

Hello,

If you post some sample rows and show the output you want when those rows are processed, someone will be able to make suggestions.

As posted, your question is not clear.

ap_mainframes · Posted: Wed Sep 17, 2008 9:33 am

Hello,
This is how my DB2 table looks like

Feild A Feild B Feild C
Tom Toronto Postalcode1
Tom Toronto Postalcode1
Tom Toronto Postalcode1
Harry Montreal Postalcode2
Harry Montreal Postalcode2

My output should be

Tom Toronto Postalcode1
Tom Toronto Postalcode1
Tom Toronto Postalcode1
Harry Montreal Postalcode2
Harry Montreal Postalcode2

Please note that I cant hardcode these values in where clause.

dick scherrer · Posted: Wed Sep 17, 2008 11:26 am

Hello,

Your sample data does not deal with selecting duplicates. . . A simple SELECT * with no WHERE would get that result.

Suggest you post more representative data including some rows that would not be selected as well as some that would.

Cristopher · New User Joined: 31 Jul 2008 Posts: 53 Location: NY

ap,
as Dick has indicated your requirement is not clear enough to suggest a solution.
If you wish to identify only the duplicates in the table on all the 3 fields thn this query might help