select t.ps_paybill_id ,count(*),t.payway_id,t.waybill_code,t.site_id from
ps_paybill t
group by t.ps_paybill_id,t.payway_id,t.waybill_code,t.site_id
having count(*)>1
检查是否有重复数据
转载于:https://my.oschina.net/myc/blog/53367