Çó¸ßÊÖдһÌõsqlÓï¾ä - Oracle / »ù´¡ºÍ¹ÜÀí

Îҵıí½á¹¹ÊÇ£º
create table T_CITY_WEB_CHANNEL_REPORT
(
  OPTDATE NUMBER not null,
  NEWEXPSUBCOUNT NUMBER default 0,
  SUMEXPSUBCOUNT NUMBER default 0,
  CHANNELTYPE NUMBER,
  CITYNAME VARCHAR2(30) not null,
)
comment on column T_CITY_WEB_CHANNEL_REPORT.OPTDATE
  is 'ͳ¼ÆÈÕÆÚ ''YYYYMMDD''';
comment on column T_CITY_WEB_CHANNEL_REPORT.NEWEXPSUBCOUNT
  is 'ÐÂÔöÌåÑéÊý';
comment on column T_CITY_WEB_CHANNEL_REPORT.SUMEXPSUBCOUNT
  is 'ÀÛ¼ÆÌåÑéÊý';
comment on column T_CITY_WEB_CHANNEL_REPORT.CHANNELTYPE
  is 'ÇþµÀÀàÐÍ 1:³¬ÊÐ 2£ºÉ̳¡;
comment on column T_CITY_WEB_CHANNEL_REPORT.CITYNAME
  is 'µØÊÐÃû³Æ';

ÏÖÔÚÎÒÏëдһÌõsqlµÄÓï¾äÊÇÒªÇóÕâÑùµÄ£º
ÔÚͳ¼ÆÈÕÆÚ20100101µ½20100115Ö®¼ä£¬µØÊÐÃû³ÆÊÇaaa£¬ÇþµÀÀàÐÍÊÇ1³¬ÊУ¬ÐÂÔöÌåÑéÊýÊÇÇóÕâͳ¼ÆÈÕÆÚ·¶Î§ÄÚ£¨¼´20100101µ½20100115Ö®¼äµÄËùÓÐÐÂÔöÌåÑéÊýµÄÊý¾Ý£©µÄÇóºÍ£¬ÀÛ¼ÆÌåÑéÊýÊÇÓÃͳ¼ÆÈÕÆÚ×îеÄÄÇÌõÊý¾Ý£¨¼´20100115µÄÄÇÌõÊý¾Ý£©£¬×îºó²éѯµ½µÄÊÇÒ»ÌõÒÔÇþµÀÀàÐÍ·Ö×éÊý¾Ý£¬Çë¸ßÊÖÖ¸½Ìһϣ¬±¾ÈËÏëÁËÒ»Ì춼Ïë²»µ½£¬Ö¸µãһϣ¬Ð»Ð»

---

SQL code:
SELECT SUM(NEWEXPSUBCOUNT) AS NEWEXPSUBCOUNT ,
(SELECT SUMEXPSUBCOUNT from T_CITY_WEB_CHANNEL_REPORT
WHERE AND TO_CHAR(OPTDATE)='20100115') AS SUMEXPSUBCOUNT
from T_CITY_WEB_CHANNEL_REPORT
WHERE BYCITYNAME='AAA'
AND TO_CH