7,712
社区成员
发帖
与我相关
我的任务
分享
TRANSFORM Count(Gender) AS GenderOfCount
SELECT Group
FROM MyTable
GROUP BY Group
PIVOT Gender;
select c.[Group],c.[Gender],nz(t.[Count] ,0) as [count]
from
(select [Group], Gender, count(*) AS [Count] from MyTable Group by [Group], Gender ) as t
right join
(select * from
(select [group] from MyTable group by [group]) as a,
(select [Gender] from MyTable group by [Gender]) as b
) as c on t.[Group]=c.[Group] and t.[Gender]=c.[Gender]