select xmbm,ny from vp_xv_ccbm
group by xmbm,ny
having count(xmbm) > 1 and count(ny) > 1 ;
查询表中的特定列的重复记录
最新推荐文章于 2021-11-18 19:35:45 发布
select xmbm,ny from vp_xv_ccbm
group by xmbm,ny
having count(xmbm) > 1 and count(ny) > 1 ;