#查询某列重复数据明细
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;
总结:
先筛选出重复门店的去重后门店NO,然后用left join 匹配原表的明细;
#查询某列重复数据明细
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;
总结:
先筛选出重复门店的去重后门店NO,然后用left join 匹配原表的明细;