mysql case when合并_mysql case when问题：如何把下面的AA和AA1合并，CC和CC1，DD和DD1合并，也就是说statuslog S1和F1是一类...

最新推荐文章于 2022-10-08 17:07:33 发布

weixin_32093519

最新推荐文章于 2022-10-08 17:07:33 发布

阅读量165

点赞数

文章标签： mysql case when合并

本文链接：https://blog.csdn.net/weixin_32093519/article/details/113986381

版权

selectt.taskId,t.reportNo,CAST(t.AAASchar)S1_date,CAST(t.AA1ASchar)F1_date,CAST(t.BBASchar)S2_date,CAST(t.CCASchar)S3_date,CAST(t.CC1ASchar)F2_date,CAST(t.DDASchar)S4_dat...

select t.taskId, t.reportNo, CAST(t.AA AS char) S1_date, CAST(t.AA1 AS char) F1_date, CAST(t.BB AS char) S2_date, CAST(t.CC AS char) S3_date, CAST(t.CC1 AS char) F2_date, CAST(t.DD AS char) S4_date, CAST(t.DD1 AS char) F3_date FROM (

select taskid, reportNo, group_concat(case statuslog WHEN 'S1' then operateDate else null end) AA,

group_concat(case statuslog WHEN 'F1' then operateDate else null end) AA1,

group_concat(case statuslog WHEN 'S2' then operateDate else null end) BB,

group_concat(case statuslog WHEN 'S3' then operateDate else null end) CC,

group_concat(case statuslog WHEN 'F2' then operateDate else null end) CC1,

group_concat(case statuslog WHEN 'S4' then operateDate else null end) DD,

group_concat(case statuslog WHEN 'F3' then operateDate else null end) DD1

from v_taskreport GROUP BY taskId ORDER BY taskId

) as t

展开