hey hai eveybody

help me in sql..i have three fields namely passengerGender1,passengerGender2,passengerGender3 in single table..now i want to take count for female and male separately from the three fields..it is posssible friends?can anyone help me???thanks in advance...!!

There's no way anyone can answer that question from just the little information you've provided.

This doesn't make any sense... Why would you have 3 different fields for gender? You should have just one. If you do that you should be able to use MySQL's COUNT() and GROUP BY for what you're looking for.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.