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
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is runstats and reorg in db2?
How to find the number of rows in a db2 table?
How do I optimize a query in db2?
What are the full forms of spufi and dclgen and why are they used?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is database reorganization?
What is dbrm? What it contains?
How to check last update on table in db2?
Define db2.
How to fetch the last row from the table in SQL (db2)?
Is db2 a mainframe database?
What is cascading rollback?
How do you stop a db2 database in linux?
What is package in cobol db2?
