如何进行多表分组查询？

发布时间：2020-04-12 08:43:43

资讯分类：分组查询 COUNT a1 mrmxb

这样改试一下：r select * from (r SELECT qw, COUNT(qw) AS a1 FROM mrmxb GROUP BY qw unionr SELECT bw, COUNT(bw) AS a1 FROM mrmxb GROUP BY bw unionr SELECT sw, COUNT(sw) AS a1 FROM mrmxb GROUP BY sw unionr SELECT gw, COUNT(gw) AS a1 FROM mrmxb GROUP BY gw ORDER BY 2)derivedtblr r 看行不行。