select col1,col2,count(*) from supplier_contract group by col1,col2 having count(*) >1
查看表里重复字段的数据
最新推荐文章于 2021-09-22 21:32:50 发布
select col1,col2,count(*) from supplier_contract group by col1,col2 having count(*) >1