wenxi2367的博客

行转列 SELECT name, SUM(CASE `subject` WHEN '语文' THEN score ELSE 0 END) as '语文', SUM(CASE `subject` WHEN '数学' THEN score ELSE 0 END) as '数学' FROM tj_testscore GROUP BY name 转化后 拼接每个转化后的表 SELECT A.CID, A.jk_height, A.jk_weight, A.site, A.shop, A.team..

原始数据转化后的数据源代码：SELECT recordbytunnel.ttype, recordbytunnel.tsequense, tunnelId, MAX(CASE DataType WHEN 1 THEN RowCount ELSE 0 END) AS '发送总数Cmpp', MAX(CASE DataType WHEN 2 THEN RowCount ELSE 0 END) AS '...