select a.* from chunyan_PROMO_result_2 a where a.subs_id in (select subs_id from chunyan_PROMO_result_2 group by subs_id having count(subs_id)>1 ) ;
sql 查找重复值,整行重复
最新推荐文章于 2023-12-14 15:26:22 发布
select a.* from chunyan_PROMO_result_2 a where a.subs_id in (select subs_id from chunyan_PROMO_result_2 group by subs_id having count(subs_id)>1 ) ;