mysql 查重复数据
SELECT
b.productSkuId,
FROM_UNIXTIME( b.createTime/1000)
FROM
BrandActivityProduct a
LEFT JOIN BrandActivityProductPrice b ON a.refrenceId = b.activityProductId
WHERE
a.delState = 0
AND a.activityId = "88726C80329D4E6EBA1D0D3DBE09C5ED"
GROUP BY
b.productSkuId
HAVING
COUNT(b.productSkuId) > 1
转载请说明:转载自http://www.cnblogs.com/yiyongyao/