SQL分组统计问题

Question

我有下面一条SQL文，不分组直接统计数据是对的见SQL1
SQL1:SELECT   SUM (B.Oldstockscalar) AS oldscalar,
         SUM (B.NEWSTOCKSCALAR) AS checkscalar,
         SUM ( (CASE WHEN b.checkscalar < 0 THEN b.checkscalar ELSE 0 END))
            AS lossscalar,
         SUM ( (CASE WHEN b.checkscalar > 0 THEN b.checkscalar ELSE 0 END))
            AS profitscalar
  FROM   fx_checkbookprofit b, FX_STOREROOMINFO c
 WHERE   b.roomid = c.roomid上面的SQL文一分组数据居然多了，如下SQL2
SQL2
SELECT   SUM (checkscalar),
         SUM (lossscalar),
         SUM (profitscalar),
         COUNT (1)
  FROM   (  SELECT   c.roomcode AS roomname,
                     SUM (B.Oldstockscalar) AS oldscalar,
                     SUM (B.NEWSTOCKSCALAR) AS checkscalar,
                     SUM( (CASE
                              WHEN b.checkscalar < 0 THEN b.checkscalar
                              ELSE 0
                           END))
                        AS lossscalar,
                     SUM( (CASE
                              WHEN b.checkscalar > 0 THEN b.checkscalar
                              ELSE 0
                           END))
                        AS profitscalar
              FROM   fx_checkbookprofit b, FX_STOREROOMINFO c
             WHERE   b.roomid = c.roomid
          GROUP BY   c.roomcode)出现这问题是怎么回事？谢谢

Answer 1

哈哈,kingkingzhu接分比我还厉害.

Answer 2

坚持每天来CSDN 学习加接分