SELECT *
FROM AAA
WHERE ( NO, PL-NO, CDK, QPF, ZPF, LJB, HNO ) IN (SELECT NO, PL-NO, CDK, QPF, ZPF, LJB, HNO FROM AAA
GROUP BY NO, PL-NO, CDK, QPF, ZPF, LJB, HNO
HAVING COUNT(*)>1)
ORDER BY NO, PL-NO, CDK, QPF, ZPF, LJB, HNO, aa, bb, cc, dd
其中AAA是表名,NO, PL-NO, CDK, QPF, ZPF, LJB, HNO, aa, bb, cc, dd都是表AAA的属性。