SQL查找出某一列中存在重复的数据_weixin_33711647的博客

select a.*
  from businaccount a, customer c,custperson cust
 where a.client_id IN (SELECT b.client_id
                         FROM businaccount b
                        GROUP BY b.client_id
                       HAVING COUNT(*) > 1)
   and a.client_id = c.client_id
   and c.client_id = cust.client_id
 order by a.client_id asc;s