Hi,
Being new to DB2 I'm having a small problem that I'm sure is quite easy to someone smarter than me.
I have a table with duplicate entries and I need to know how to code a query to exctract certain fields from the table with a count > 1. I can do this with one field however I need to do this with multiple fields.
Working 1 Field Query,
- select field_3 from CUSTOMER where field_3 <> ' ' group by field_3 having count(*) > 1
What doesn't work,
- select * from CUSTOMER where field_3 <> ' ' group by field_3 having count(*) > 1
Table Name:
CUSTOMER
# of Fields:
5 (e.g. Filed_1, Field_2, Field_3, etc)
If some could help me with this I would be eternally grateful.
Thanks in advance.......