SELECT
jgm,wdmc,
IF(ywid='01',ddrs,-1) AS ywbh1,
IF(ywid='02',ddrs,-1) AS ywbh2,
IF(ywid='03',ddrs,-1) AS ywbh3
FROM view_wd_ywxx_ddrs where length(ywid)>0
GROUP BY jgm ;
...全文
3469打赏收藏
MYSQL 在视图上进行行列转换问题
问题简单描述如下,在视图上进行行列转换时,结果不正常,每条记录只能转换一列,详细情况如下 : 视图数据如下: 查询结果为 : 进行行列转换 SQL脚本如下 : SELECT jgm,wdmc, IF(ywid='01',ddrs,-1) AS ywbh1, IF(ywid='02',ddrs,-1) AS ywbh2, IF(ywid='03',ddrs,-1) AS ywbh3 FROM view_wd_ywxx_ddrs where length(ywid)>0 GROUP BY jgm ;
SELECT
jgm,wdmc,
SUM(IF(ywid='01',ddrs,-1)) AS ywbh1,
SUM( IF(ywid='02',ddrs,-1)) AS ywbh2,
SUM(IF(ywid='03',ddrs,-1)) AS ywbh3
FROM view_wd_ywxx_ddrs where length(ywid)>0
GROUP BY jgm,wdmc