Answer Posted / mahesh vasudevan
Select <col-name> from table A1 and A2
where A1.Col = A2.Col.
This should be an inner join. Then you are finding the
intersection of the key values...if you want to find the
duplicates for all matching column of the rows code AND
condition for join with all those columns.....by the way
there are different easy ways to find it. but this is one of
the way.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is ibm db2 client?
What are db2 tables?
What is explain plan in db2?
Why cursor is used in db2?
Why db2 is called db2?
What is bind plan?
What does db2 blu stand for?
What r the comman abends in db2, jcl and cobol???????
What is dbrm library?
Name the various locking levels available?
What language is db2 written in?
What is page size in db2?
Is ibm db2 free?
Explain in brief how does db2 determine what lock-size to use?
How can we read records for specific member in CL? AND rpg?