使用mysql,把图一转换成图二。
图一
图二
SQL:
SELECT pid,
SUM(CASE WHEN sid='01' THEN pnum ELSE 0 END) s1id,
SUM(CASE WHEN sid='02' THEN pnum ELSE 0 END) s2id,
SUM(CASE WHEN sid='03' THEN pnum ELSE 0 END) s3id
from tb_a
GROUP BY pid
使用mysql,把图一转换成图二。
图一
图二
SQL:
SELECT pid,
SUM(CASE WHEN sid='01' THEN pnum ELSE 0 END) s1id,
SUM(CASE WHEN sid='02' THEN pnum ELSE 0 END) s2id,
SUM(CASE WHEN sid='03' THEN pnum ELSE 0 END) s3id
from tb_a
GROUP BY pid