I have a table with this 2 columns between others

Diagnos Num
Sex Num

Now I want to find out how many of each sex there are on each diagnos. How do I do that!

Regards

Tenerife

something like:

select sum(sex ),diagnose from MyTableName
group by diagnose

anna

Select sex, diagnosis, Count(*) As RecCount
From YourTable
Group by sex, diagnosis;