Forum Discussion

meenakshi's avatar
meenakshi
New Contributor
3 years ago

Finding Duplicate data existing in Database

I have 2 fields called Product_ID and Partner Product_ID where lets say product ID is P-001 and Partner product ID is P-P-0001 which is already existing in database with this combination and again if...
alchemiz's avatar
alchemiz
Contributor III
3 years ago
Copy LinkReport

Here’s a simple script that will return all duplicate product_id and partner product_id combination

select	a.part_prod_id, a.num_row 
from	(
			select	concat([parter product id], [product id]) as part_prod_id, count(concat([parter product id], [product id])) as num_row
			from	yourtable (nolock) 
			group	by concat([parter product id], [product id])
		) a
where	a.num_row > 1