2022年7月15日

mysql 重复记录

摘要: SELECT *,_rowidFROM jk_his_zybrcryxxb aWHERE (a.brid, a.zycs,a.ryrq) IN ( SELECT brid,zycs,ryrq FROM jk_his_zybrcryxxb GROUP BY brid,zycs,ryrq HAVING 阅读全文

posted @ 2022-07-15 09:10 zyp_java_net 阅读(14) 评论(0) 推荐(0) 编辑

MySQL中删除重复数据只保留一条

摘要: DELETEFROM jk_his_zybrcryxxb aWHERE (a.brid, a.zycs,a.ryrq) IN ( select * FROM( SELECT brid, zycs,ryrq FROM jk_his_zybrcryxxb GROUP BY brid,zycs,ryrq 阅读全文

posted @ 2022-07-15 08:00 zyp_java_net 阅读(104) 评论(0) 推荐(0) 编辑

导航