select id from table_info group by sfzh having count(*) > 1;
分组筛选数据,某个数据字段比如说患者就诊超过一次的,身份证号会重复出现的,sql语句,备忘用的...
最新推荐文章于 2021-12-22 21:08:41 发布
select id from table_info group by sfzh having count(*) > 1;