SQL求指导
select
split("aaa,bbb,ccc",",")[0] as t1
,split("aaa,bbb,ccc",",")[1] as t2
,split("aaa,bbb,ccc",",")[2] as t3
——————————————————
并非所有数据库都支持split函数,不支持的话,可能还需要写存储过程或通过其他思路实现;
推荐-直接在报表端通过split()函数分割字段内容,扩展展示数组元素值;
——————————————
SELECT 字段B FROM 表A
select concat(aaa,',',bbb,',',ccc) from 表A