数据库的表结构是这样的
然后需要得到这样的查询结果
sql语句是这样的
select name,
'b1' as b1, sum(case when bag = 'b1' then money end),
'b2' as b2, sum(case when bag = 'b2' then money end),
'sum' as summ,sum(money)
from testtable
group by name;
数据库的表结构是这样的
然后需要得到这样的查询结果
sql语句是这样的
select name,
'b1' as b1, sum(case when bag = 'b1' then money end),
'b2' as b2, sum(case when bag = 'b2' then money end),
'sum' as summ,sum(money)
from testtable
group by name;