could you please help on this.
i am trying to update the table am getting the Target row updated by MUltiple source rows error.
both tables having same structure ,update statement like below.
update table a
a.primary index=b.primary index.
how can i find the duplicate rows?
You can find the duplicates by:
SELECT <primary index column(s)>, count(*) FROM <Table Name> GROUP BY <primary index column(s)> HAVING COUNT(*) > 1
could you pls help how to find DUPS below statements.
Here we are updating same table....soure and target tables are same ..
could you pls suggest how can we find Dups...
from table 2
(select * from Table 3
where conditions)) S1