oracle SUM函数

select change_type as change_type, sum(points1) as points
  from (select DECODE(p.change_type,
                      1,
                      ' 兑换商品',
                      2,
                      '兑换优惠券',
                      3,
                      '订单获得',
                      4,
                      '评价获得',
                      5,
                      '注册获得',
                      6,
                      '人工增加',
                      7,
                      '订单退还',
                      8,
                      '订单取消退回',
                      9,
                      '邮箱验证',
                      10,
                      '评价获得',
                      11,
                      '评价获得',
                      12,
                      '评价获得',
                      13,
                      '评价获得',
                      15,
                      '抵现消费',
                      16,
                      '积分过期',
                      20,
                      '签到',
                      29,
                      '门店消费',
                      30,
                      '账户合并',
                      null) as change_type,
               sum(p.points) as points1
          from member_points_his p
         where 1 = 1
         group by change_type)
 where change_type is not null
 group by change_type

注意:

在页面展示的时候,sum函数之后要有as 字段 这一步,否则回报列名无效的错误

 

 

select change_type1 as change_type, sum(points1) as points
  from (select DECODE(p.change_type,
                      1,
                      ' 兑换商品',
                      2,
                      '兑换优惠券',
                      3,
                      '订单获得',
                      4,
                      '评价获得',
                      5,
                      '注册获得',
                      6,
                      '人工增加',
                      7,
                      '订单退还',
                      8,
                      '订单取消退回',
                      9,
                      '邮箱验证',
                      10,
                      '评价获得',
                      11,
                      '评价获得',
                      12,
                      '评价获得',
                      13,
                      '评价获得',
                      15,
                      '抵现消费',
                      16,
                      '积分过期',
                      20,
                      '签到',
                      29,
                      '门店消费',
                      30,
                      '账户合并',
                      null) as change_type1,
               sum(p.points) as points1
          from member_points_his p
         where 1 = 1
         group by change_type)
 where change_type1 is not null
 group by change_type1