mysql - 按 UNION ALL 中的值分组的计数

Question

我在 mySQL 中有以下查询

`SELECT * FROM (select assoc1 from fab_cbd where tournament = 65   
union all    
select assoc2 from fab_cbd where tournament = 65) x`

使用它我可以获得包含这两列值的完整列表。我想要做的是按这些值进行分组并计算出现次数。

提前致谢。

Answer 1

然后添加分组依据:

SELECT assoc, count(*)
FROM (select assoc1 as assoc from fab_cbd where tournament = 65   
      union all    
      select assoc2 from fab_cbd where tournament = 65
     ) x
GROUP BY assoc;