子查询--一时懵掉了

 

SELECT T.OBCODE,
       T.UP_FROM,
       T.OB_TOTLE_NUMBER,
       (SELECT COUNT(*)
          FROM T_OPB_YEAR_RESULT
         WHERE SATA_YEAR = '2011'
           AND OBCODE = T.OBCODE
           AND UP_FROM = T.UP_FROM) AS COUNT

  FROM (SELECT OBCODE, UP_FROM, SUM(OB_TOTLE_NUMBER) AS OB_TOTLE_NUMBER
          FROM T_OPB_MONTH_RESULT
         WHERE TO_CHAR(TO_DATE(SATA_MONTH, 'YYYY-MM'), 'YYYY') = '2011'
         GROUP BY OBCODE, UP_FROM) T