求教SQL语句.

Question

 SELECT NVL(SUM(CASE
                     WHEN TRUNC(B.SHOULISJ, 'dd') = TRUNC(SYSDATE, 'dd') AND
                          A.LIMITTYPE = 1 THEN
                      1
                     ELSE
                      0
                   END),
               0) into sjjrsl,
           NVL(SUM(CASE                     WHEN TRUNC(B.BANJIESJ, 'dd') = TRUNC(SYSDATE, 'dd') AND
                          A.LIMITTYPE = 1 THEN
                      1
                     ELSE
                      0
                   END),
               0) into sjjrbj
      FROM T_JC_XZXK_BUSIINDEX B, T_JC_XZXK_BUSI_TIMELIMIT A
     WHERE B.YWLSH = A.BUSIINDEXID;查询多个就报错不允许使用分组函数?
查一个就可以.
语法?

Answer 1

语法不对，应该只有一个INTO子句：SELECT SUM(A),SUM(B) INTO v_a,v_b FROM TABLE