I have the following T_SQL query which produces an aggregate showing a breakdown of my data by gender.
Select member.Gender, COUNT(1) 'Count'
From Member,Member_Association
WHERE Member.member_Number=Member_Association.Member_Number AND Member_Association.Status='a'
Group By Gender
How can I also show the related percentages (e.g. F=44% M=22% Null=34%)?
Thanks in advance,
Austin