22,209
社区成员
发帖
与我相关
我的任务
分享
(SELECT [user_id],[point_type],SUM([point]) as pointsum,sum(case when [point] > 0 then point else 0 end)as pointacc,
sum(case when [point] < 0 then point else 0 end)as pointdec
FROM [workpointmanage_sass].[dbo].[tb_point]
group by [user_id],[point_type]) order by user_id,[point_type]