급히 만들었어요.
전월말 잔고 10만원이하 고객이 당월말 10만원 이상으로 변경된 수 구하는 쿼리인데요,
서브쿼리가 너무 많은거 같고 중복도 심한거 같고... 그냥 말 그대로 짰는데 좀 더 간편하게 줄일 수 있을까요?
초보라서 죄송합니다.... ㅠ_ㅠ
-----------------------------------------------------------------------------------------------------
SELECT COUNT(X1.IDNO)
FROM (
SELECT V.Idno IDNO
FROM (
SELECT B.Idno Idno
,SUM(A.AmotAsstTot) AmotAsstTot
FROM DWRSASST_NEW A
,DWACMAST B
,MASS_CUST_LIST C
WHERE A.DateBasic = '20091231'
AND C.Idno = B.Idno
AND A.Brchno = B.Brchno
AND A.DivGood = B.DivGood
AND A.Gujano = B.Gujano
GROUP BY B.Idno
)V
WHERE V.AmotAsstTot < 100000
) X1
, (
SELECT V.Idno IDNO
FROM (
SELECT B.Idno Idno
,SUM(A.AmotAsstTot) AmotAsstTot
FROM DWRSASST_NEW A
,DWACMAST B
,MASS_CUST_LIST C
WHERE A.DateBasic = '20100131'
AND C.Idno = B.Idno
AND A.Brchno = B.Brchno
AND A.DivGood = B.DivGood
AND A.Gujano = B.Gujano
GROUP BY B.Idno
)V
WHERE V.AmotAsstTot > 100000
)X2
WHERE X1.IDNO = X2.IDNO |