Interested to Buy Any Domain ? << Click Here >> for more details...
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 clustering index in the db2 database?
What are foreign keys in db2?
What is dclgen (declaration generator)?
What is scrollable cursor in db2?
What is the difference between cursor stability and repeatable read isolation levels?
When reorg is used?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is check constraint in db2?
Define declaration generator (dclgen).
Which component is responsible for db2 startup and shutdown?
What is dbrm library?
What are the contents of dclgen?
what is the sqlcode -501
What is db2 command?
