Expert: Edson - 6/21/2009

Question
There is a table with three columns name,location& sex.in name column there are different names and in location there are cities like bangalore, chennai, madurai,mhyderbad and sex there are male and female. and my question is using single query we have to display the amount of male and female from each every city.
           i am waiting for your reply
                 thanking you

Answer
select count(*), sex, substr(location,..,..)
 from table
group by sex, substr(location,..,..)

If it´s not what you are expecting, please give some more example and I will create the table here in my database and post to you th results.

Regards...
Wait feedback