1、sqlite:group_concat()多列
参考https://qa.1r1g.com/sf/ask/685814741/
SELECT
step,
group_concat(concat) AS formated
FROM (
SELECT
step,
CASE
WHEN intvl IS NULL THEN position || ',0'
ELSE position || ',' || intvl
END AS concat
FROM processdetail2 order by moverno
)
GROUP BY step
取出结果：
step formated
1 90,0.1,60,0,30,0.2
2 600,0.3,300,0.1,150,0.2
3 900,0,600,0,200,0
标签：sqlite,600,转置,step,多列,concat From： https://www.cnblogs.com/xihong2014/p/17015146.html