select change_type as change_type, sum(points1) as points
from (select DECODE(p.change_type,
,
' 兑换商品',
,
'兑换优惠券',
,
'订单获得',
,
'评价获得',
,
'注册获得',
,
'人工增加',
,
'订单退还',
,
'订单取消退回',
,
'邮箱验证',
,
'评价获得',
,
'评价获得',
,
'评价获得',
,
'评价获得',
,
'抵现消费',
,
'积分过期',
,
'签到',
,
'门店消费',
,
'账户合并',
null) as change_type,
sum(p.points) as points1
from member_points_his p
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,
,
' 兑换商品',
,
'兑换优惠券',
,
'订单获得',
,
'评价获得',
,
'注册获得',
,
'人工增加',
,
'订单退还',
,
'订单取消退回',
,
'邮箱验证',
,
'评价获得',
,
'评价获得',
,
'评价获得',
,
'评价获得',
,
'抵现消费',
,
'积分过期',
,
'签到',
,
'门店消费',
,
'账户合并',
null) as change_type1,
sum(p.points) as points1
from member_points_his p
group by change_type)
where change_type1 is not null
group by change_type1