查某张表中某字段重复记录大于一的语句

分类: IT文章 • 2024-11-20 14:47:30

查某张表中某字段重复记录大于1的语句

select * from tab1 where xh in (select xh from tab1 group by xh having count(*)>1 )