MySQL子查询

发布时间：2022-04-08 14:36:17 所属栏目：MySql教程来源：互联网

导读：SELECT SUBSTRING(REPLACE(REPLACE(REPLACE(REPLACE(do,B,),.,0),_,1),-,1),1,32),B.id,B.du,B.phone,B.createdate, B.modifydate FROM ca.pro AS B WHERE SUBSTRING(REPLACE(REPLACE(REPLACE(REPLACE(do,B,),.,0),_,1),-,1),1,32) IN (SELECT A.do1 FROM (S

SELECT

  SUBSTRING(REPLACE(REPLACE(REPLACE(REPLACE(do,'B',''),'.','0'),'_','1'),'-','1'),1,32),B.id,B.du,B.phone,B.createdate,

  B.modifydate FROM ca.pro AS B

  WHERE SUBSTRING(REPLACE(REPLACE(REPLACE(REPLACE(do,'B',''),'.','0'),'_','1'),'-','1'),1,32) IN

  (SELECT A.do1 FROM

(SELECT SUBSTRING(REPLACE(REPLACE(REPLACE(REPLACE(do,'B',''),'.','0'),'_','1'),'-','1'),1,32) AS do1,COUNT(*) AS count1 FROM ca.pro

GROUP BY SUBSTRING(REPLACE(REPLACE(REPLACE(REPLACE(do,'B',''),'.','0'),'_','1'),'-','1'),1,32)

HAVING COUNT(*) >1) AS A)

（编辑：衡水站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!