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 the difference between oracle and db2?
How to find the maximum value in a column in the db2 database?
What is sqlca’s maximum length?
What is db2 purescale?
Which is faster delete or truncate?
Mention the location where the output received from explain statement is stored.
What is database alias db2?
What is db2 plan table?
Mention the downsides of page level lock.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What are types of indexes?
What is the maximum number of columns in a db2 table?
How do you select a row using indexes in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the latest version of ibm db2?
