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 reorg and runstats in db2?
What is the difference between db2 and oracle?
When do you specify the isolation level?
Define check constraint.
Why do we need reorg in db2?
What is the maximum length of sqlca?
What is meant by dclgen?
What are concurrency issues?
What is db2?
Explain about dbrm.
What is bind in db2?
What is db2 bind?
What is the purpose of using commit?
What is meant by explain?
What is the default page size of buffer pools?