Based on the situation, one can use Union/Inner Join.

How can you compare table column after update and before
update?

Question Posted / harsha

Answer Posted / harsha

Is This Answer Correct ?

0 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What do you mean by cursor?

1030

Mention data types used in db2 ?

1200

What is coalesce in db2?

1183

How can we retrieve the total number of records in RPG & CLLE?

707

Explain about open switch business continuity software?

1183

How to get the ddl of a table in db2?

1168

What is the max length of sqlca?

1268

How to compare data between two tables in db2?

1137

How to find the number of rows in a db2 table?

1154

What is the difference between nvl and coalesce?

1106

What is multi row fetch in db2?

1101

How to rename a table in DB2 ?

1145

What is difference between alias and synonym in db2?

1195

What is the usage of open cursor command?

1143

What is the picture clause of null indicator variable?

1178