SELECT uid, type, amount,auid , sum(amount) as total FROM `abc_log_commision` group by uid, auid, type, amount HAVING COUNT(uid)>1
uid, auid, type, amount四项都相同的重复
SELECT uid, type, amount,auid , sum(amount) as total FROM `abc_log_commision` group by uid, auid, type, amount HAVING COUNT(uid)>1
uid, auid, type, amount四项都相同的重复
发表评论: