-
-
18754176079 数据达人Lv4
发表于2021-7-7 10:55
悬赏10
已解决
楼主
select t1.dm, t1.maxvalue, t2.cq, t3.per from
(select dm, max(value) maxvalue from test where dm not like '%超欠' and dm not like '%百分比' group by dm) t1
left join
(select substr(dm, 1, instr(dm, '超欠')-1) dm_cq, max(value) cq from test where dm like '%超欠' group by dm) t2
on t1.dm = t2.dm_cq
left join
(select substr(dm, 1, instr(dm, '百分比')-1) dm_per, max(value) per from test where dm like '%百分比' group by dm) t3
on t1.dm = t3.dm_per;
请问一下报表可以实现像sql那样合并为一行的功能吗？（上面语句是有问题的，合并好的数据并不是对的）
(select dm, max(value) maxvalue from test where dm not like '%超欠' and dm not like '%百分比' group by dm) t1
left join
(select substr(dm, 1, instr(dm, '超欠')-1) dm_cq, max(value) cq from test where dm like '%超欠' group by dm) t2
on t1.dm = t2.dm_cq
left join
(select substr(dm, 1, instr(dm, '百分比')-1) dm_per, max(value) per from test where dm like '%百分比' group by dm) t3
on t1.dm = t3.dm_per;
请问一下报表可以实现像sql那样合并为一行的功能吗？（上面语句是有问题的，合并好的数据并不是对的）
最近看过此主题的会员
3个回答
-
18754176079 数据达人Lv4
板凳
果冻出场 发表于 2021-7-7 11:03
首先得给一个正确的sql.或者给出模拟数据,和要实现的最终效果.
这里面有数据例子以及展示效果
新建 Microsoft Excel 工作表.zip
(7.27 KB, 下载次数: )
