Question

SQL如何多表分组统计一起显示

select * from (
SELECT qw, COUNT(qw) AS a1 FROM mrmxb GROUP BY qw ORDER BY a1 union
SELECT bw, COUNT(bw) AS a1 FROM mrmxb GROUP BY bw ORDER BY a2 union
SELECT sw, COUNT(sw) AS a1 FROM mrmxb GROUP BY sw ORDER BY a3 union
SELECT gw, COUNT(gw) AS a1 FROM mrmxb GROUP BY gw ORDER BY a4)derivedtbl

Answer 1

这样改试一下：
select * from (
SELECT qw, COUNT(qw) AS a1 FROM mrmxb GROUP BY qw union
SELECT bw, COUNT(bw) AS a1 FROM mrmxb GROUP BY bw union
SELECT sw, COUNT(sw) AS a1 FROM mrmxb GROUP BY sw union
SELECT gw, COUNT(gw) AS a1 FROM mrmxb GROUP BY gw ORDER BY 2)derivedtbl

看行不行。

追问

不要order by 就行了 ，其实我是想按列显示 例如 qw,a1,bw,a2,sw,a3,gw,a4 能这样显示吗？

追答

同一行的qw,bw,sw,gw的值一样吗？