查询Quality失效与不失效的记录
SELECT QR.ORGANIZATION_ID,SUM(DECODE(QR.STATUS,1,0,1)) GOOD,
SUM(DECODE(QR.STATUS,2,0,1)) BAD
FROM QA_RESULTS QR ,
QA_PLANS QP
WHERE QR.PLAN_ID= QP.PLAN_ID
AND TO_CHAR(QR.TRANSACTION_DATE,'YYYYMM')>='200512'
AND QR.ORGANIZATION_ID=QP.ORGANIZATION_ID
and QP.ORGANIZATION_ID =11
and QR.PLAN_ID=156
group by QR.ORGANIZATION_ID
SELECT QR.ORGANIZATION_ID,SUM(DECODE(QR.STATUS,1,0,1)) GOOD,
SUM(DECODE(QR.STATUS,2,0,1)) BAD
FROM QA_RESULTS QR ,
QA_PLANS QP
WHERE QR.PLAN_ID= QP.PLAN_ID
AND TO_CHAR(QR.TRANSACTION_DATE,'YYYYMM')>='200512'
AND QR.ORGANIZATION_ID=QP.ORGANIZATION_ID
and QP.ORGANIZATION_ID =11
and QR.PLAN_ID=156
group by QR.ORGANIZATION_ID
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/41594/viewspace-50528/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/41594/viewspace-50528/