查询表重复数据:select * from ms_brda a where a.sfzh in (select b.sfzh from ms_brda b group by b.sfzh having count(1)>1 ) order by a.sfzh