weixin_43550122的博客

原创 MySQL查询某列重复数据的明细

#查询某列重复数据明细 select b.* from (select 门店NO from shop_info_2018to2020 group by 门店NO having count(*) >= 2) as a left join shop_info_2018to2020 b on a.门店NO=b.门店NO order by 门店nO; 总结： 先筛选出重复门店的去重后门店N...