我自己贴一个最不济的:问题是多个指标效率就太差了SELECT A.JGM,A.BZH,A.KMKZZ,CURRENT DATE,SNRJYE,QNRJYE
FROM
(SELECT JGM,BZH,KMKZZ,AVG(ABS(BRJYE-BRDYE)) AS SNRJYE
FROM DB2ADMIN.ZZRZZ
WHERE YEAR(RQ) = YEAR(CURRENT DATE)-1
GROUP BY JGM,BZH,KMKZZ) AS A,
(SELECT JGM,BZH,KMKZZ,AVG(ABS(BRJYE-BRDYE)) AS QNRJYE
FROM DB2ADMIN.ZZRZZ
WHERE YEAR(RQ) = YEAR(CURRENT DATE)-2
GROUP BY JGM,BZH,KMKZZ) AS B
WHERE A.JGM=B.JGM
AND A.BZH=B.BZH
AND A.KMKZZ=B.KMKZZ