56,679
社区成员
发帖
与我相关
我的任务
分享
select
uName as 用户名,
sum(case when pName='广州' then amount else 0) as 广州,
sum(case when pName='羊城' then amount else 0) as 羊城,
sum(case when pName='南方' then amount else 0) as 南方
from
tb
group by
uName
select uName as 用户名,
sum(if(pName='广州',amount,0)) as 广州,
sum(if(pName='羊城',amount,0)) as 羊城,
sum(if(pName='南方',amount,0)) as 南方
from 表中数据
group by uName