大佬,有没有其他sql改造的方法?
业务层面需要 order by 这个特性。
修复方法:在最外层子查询增加 order by 子查询
SELECT group_concat(concat('{"key":"', 'name2', '","value":[', '{"key":"name1","value":"', 1, '"}', ']}') order by a) CH_DATA_KEY
FROM (
select round(1 / count(distinct '1'), 2) as a
from t2
join (
select distinct u.c from t2 as u) as w
order by a ) t;