最近用sqlite做统计，要实现行列转换。
行是：
要达到的效果是：
使用的语句是：
行转成列：
SELECT zldwdm,sum(mj) as total,
sum(CASE WHEN dlbm='01' THEN mj ELSE 0 END) AS '01',
sum(CASE WHEN dlbm='02' THEN mj ELSE 0 END) AS '02',
sum(CASE WHEN dlbm='03' THEN mj ELSE 0 END) AS '03',
sum(CASE WHEN dlbm='04' THEN mj ELSE 0 END) AS '04',
sum(CASE WHEN dlbm='20' THEN mj ELSE 0 END) AS '20',
版权声明：本文为liumengcheng原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。