一张这样表
id color xh value
1 red X 12
2 red XX 23
3 red XXX 13
4 blue X 4234
5 blue XX 2342
6 blue XXX 5334要得到这样的结果
x xx xxx
red 12 23 13
blue 4234 2342 5334SQL 怎么写
id color xh value
1 red X 12
2 red XX 23
3 red XXX 13
4 blue X 4234
5 blue XX 2342
6 blue XXX 5334要得到这样的结果
x xx xxx
red 12 23 13
blue 4234 2342 5334SQL 怎么写
color,
x=sum(case when xh='X' then value else 0 end),
xx=sum(case when xh='XX' then value else 0 end),
xxx=sum(case when xh='XXX' then value else 0 end)
from
tb
group by
color