select * from himall_exchangecode where codeID in( select codeID from himall_exchangecode GROUP BY codeID HAVING count(codeID)>1)
一句代码查询重复数据
最新推荐文章于 2023-03-07 10:31:11 发布
select * from himall_exchangecode where codeID in( select codeID from himall_exchangecode GROUP BY codeID HAVING count(codeID)>1)