I have a column called 'GENEDER' in my table. I would like to count both the number of Male and Female. How should I write the SQL code? <BR><BR>Thanks,<BR>Jenny
Pretty basic. Use a GROUP BY statement.<BR><BR>select gender, count(gender)<BR>from yourtable<BR>GROUP BY gender
Thanks very much!!!