实用SQL语句

通过group by查找某个字段的重复值

select p.CIID,count(p.CIID) from T_PaymentInformation p group by p.CIID having count(p.CIID)>1;