1.SELECT * FROM “表名” GROUP BY billcode HAVING COUNT()>1*
2.select billcode from (select * from “表名” GROUP BY billcode having count()>1) a group by “。。。” having count()>1
查询数据库中的重复数据
最新推荐文章于 2024-04-16 13:41:20 发布
1.SELECT * FROM “表名” GROUP BY billcode HAVING COUNT()>1*
2.select billcode from (select * from “表名” GROUP BY billcode having count()>1) a group by “。。。” having count()>1