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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.