sql查询重复数据

SELECT count(*),tod02.platform_number,tod02.payment_bh FROM today_order tod02 
GROUP BY tod02.platform_number,tod02.payment_bh
HAVING  count(*)>1

原文地址:https://www.cnblogs.com/q1359720840/p/10401830.html