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;

总结：
先筛选出重复门店的去重后门店NO，然后用left join 匹配原表的明细；