mysql sql找出一个表中多个字段重复的值时间:2022-03-17 14:27:24SELECT s.periodsno,s.sitename,t.* FROM subcampaign_doctor t LEFT JOIN `subcampaign` s ON s.id=t.subCampaignId WHERE (SELECT COUNT(1) FROM subcampaign_doctor WHERE subCampaignId=t.subCampaignId AND phone=t.phone)>1