mysql在 union 与group by后order by排序混乱
统计的sql,排序后,查出的数据前半部分是对的,后部分顺序就乱了
select (case when sum(a.n0) is null then 0 else sum(a.n0) end) n0,
(case when sum(a.n1) is null then 0 else sum(a.n1) end) n1,
(case when sum(a.n2) is null then 0 ...
原创
2020-04-18 11:58:43 ·
720 阅读 ·
1 评论