Pradeep wrote:
How we can eliminate duplicate records using SQL query.
Problem is :
Suppose there are two tables: TABLE1 (10 columns) & TABLE2(7 columns).
I need to eliminate duplicate from these two tables. 5 columns are
common in these
tables. With the help of Group By,Order By and Having condition how we
can eliminate
duplicates.
Can anyone give me more information regarding this.
Can you provide example data and output?
Given that you have two tables it's not obvious what you mean by
duplicate records. Also it's important to know whether there is a
primary key.
You are on DB2 zOS?
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab