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
Why select is not preferred in embedded sql programs?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Can there be more than one cursor open for any program?
Explain about rct.
What is the use of dclgen in db2?
Why do chiropractors use drop table?
Outputs of explain are with matchcols = 0. What does this signify?
What does db2 stand for?
Give the name of some fields form sqlca.
What is a db2 table?
How to fetch the last row from the table in SQL (db2)?
What is difference between rollback and commit?
What is the use of value function?
What is the role of data manager in the db2 database?
What is concurrency?
