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
Is db2 relational database?
What is database reorganization?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is drop table?
Which isolation level provides highest data integrity?
Is db2 a mainframe database?
What is null in db2?
What is deadlock in db2?
What is db2 bind?
What is bind package and plan in db2?
Is it possible using max on a char column?
What is a bind in db2?
What are concurrency issues?
What is plan in cobol db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?