select id from table_info group by sfzh having count(*) > 1;
分组筛选数据,某个数据字段比如说患者就诊超过一次的,身份证号会重复出现的,sql语句,备忘用的
-------------------------------------------------
保持专注,只做一件事,做好这件事!@
-------------------------------------------------
select id from table_info group by sfzh having count(*) > 1;
-------------------------------------------------
保持专注,只做一件事,做好这件事!@
-------------------------------------------------