SELECT name1,pim1 FROM(SELECT name1, pim1,(CASE WHEN apim is NULL THEN '' ELSE apim END) apim FROM pim LEFT JOIN ( SELECT pim1 apim FROM ( SELECT name1, pim1, COUNT(pim1) cishu FROM pim GROUP BY pim1 ) a WHERE cishu <> '1' ) b ON pim.pim1 = b.apim) c WHERE (pim1 = apim AND name1 != apim) or pim1!= apim自己改改试下吧
SELECT NAME1, PIM1 FROM B1 WHERE PIM1 <> NAME1 OR PIM1 NOT IN (SELECT PIM1 FROM B1 GROUP BY PIM1 HAVING COUNT(1) > 1)
name1,
pim1,(CASE WHEN apim is NULL THEN '' ELSE apim END) apim
FROM
pim
LEFT JOIN (
SELECT
pim1 apim
FROM
(
SELECT
name1,
pim1,
COUNT(pim1) cishu
FROM
pim
GROUP BY
pim1
) a
WHERE
cishu <> '1'
) b
ON pim.pim1 = b.apim) c
WHERE
(pim1 = apim
AND name1 != apim) or pim1!= apim自己改改试下吧
FROM B1
WHERE PIM1 <> NAME1
OR PIM1 NOT IN (SELECT PIM1 FROM B1 GROUP BY PIM1 HAVING COUNT(1) > 1)