select userid,sum(if(type='工资',acmoney,0)) as 工资合计 ,
sum(if(type='奖金',acmoney,0)) as 奖金,
sum(if(type='提成',acmoney,0)) as 提成
from tt group by userid
sum(if(type='奖金',acmoney,0)) as 奖金,
sum(if(type='提成',acmoney,0)) as 提成
from tt group by userid
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货