select e.alert_id,
e.subject,
sum( email_format) CLICK_CNT,
e.OPEN_CNT,
from e, al
where
E.alert_id = AL.alert_id
GROUP BY E.ALERT_ID,
E.SUBJECT,
E.OPEN_CNT
其中
OPENCNT是NUMBER型的
此SQL会过滤掉一些 E.SUBJECT, E.OPEN_CNT为空的类型 ( 原来是SUBJECT为空时 就不参与 SUM的计算了)但我想要 E.SUBJECT, E.OPEN_CNT为空时也要显示出来(E.SUBJECT, E.OPEN_CNT为空时也要计算CLICK_CNT的值)
可以怎么修改呢
e.subject,
sum( email_format) CLICK_CNT,
e.OPEN_CNT,
from e, al
where
E.alert_id = AL.alert_id
GROUP BY E.ALERT_ID,
E.SUBJECT,
E.OPEN_CNT
其中
OPENCNT是NUMBER型的
此SQL会过滤掉一些 E.SUBJECT, E.OPEN_CNT为空的类型 ( 原来是SUBJECT为空时 就不参与 SUM的计算了)但我想要 E.SUBJECT, E.OPEN_CNT为空时也要显示出来(E.SUBJECT, E.OPEN_CNT为空时也要计算CLICK_CNT的值)
可以怎么修改呢
SELECT E.ALERT_ID, E.SUBJECT, SUM(EMAIL_FORMAT) CLICK_CNT, E.OPEN_CNT,
FROM E, AL
WHERE E.ALERT_ID = AL.ALERT_ID
GROUP BY E.ALERT_ID, NVL(E.SUBJECT,'0'), NVL(E.OPEN_CNT,'0');
e.UNIQUE_OPEN_CNT,
FROM E, AL
WHERE E.ALERT_ID = AL.ALERT_ID
GROUP BY E.ALERT_ID, NVL(E.SUBJECT,'0'), NVL(E.OPEN_CNT,'0');
还要计算他们啊
你是要求的想这样的记录的条数吧??用COUNT( email_format) CLICK_CNT,说的不清楚