아래처럼 WITH 임시테이블로 count 조회시 1개 count 조회시는 잘 조회되는데
2개째부터는 임시테이블보다 많은 개수가 조회됩니다.
원인이 뭔지 알 수 있을까요?
WITH TEMP AS
(
SELECT
A.*
FROM <include refid="---"/> A
WHERE 1=1
<include refid="---"/>
AND PROC_STAT = 'SUCC'
)
SELECT
(SELECT COUNT(1)
FROM TEMP
WHERE 1=1
AND EMGY_FEATURE = '1'
) AS EMGY_FEATURE_CTL_CNT,
(SELECT COUNT(1)
FROM TEMP
WHERE 1=1
AND EMGY_FEATURE = '1'
AND EMGY_FEATURE_CTL = 'Y'
AND EMGY_CALL_ST = '1'
) AS EMGY_CALL_CNT
FROM DUAL;
|