select count (asin) from dbo.amazon_product_store where asin in (select asin from dbo.amazon_product_store group by asin having count (asin) > 1)
sql#查重
原文：http://www.cnblogs.com/sam-sun/p/7896596.html
