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
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What do you mean by cursor?
Is db2 free?
Describe major components of db2?
How to take backup of table in db2?
What is the role of the data page in the db2 database?
Which is faster delete or truncate?
How to create db2 table in mainframe?
How many databases can be created inside an instance in db2 ?
What is db2 command?
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?
How do I delete a table in db2?
How do I import data from excel to db2?
What r the comman abends in db2, jcl and cobol???????
Is db2 relational database?
