Hi. I tried all the queries suggested by Ian, Ben, Gert and Steve above. Still getting this: City CityCount Los Angeles 1 Boston 1 New York 1 Los Angeles 1 New York 1 New York 1
Once again, to make it clear i am looking for this resultset: City CityCount Los Angeles 2 Boston 1 New York 3 Thanks for trying guys. But no success as yet. - K On 4/28/06, Ian Skinner <[EMAIL PROTECTED]> wrote: > > Select > > City, Count(Id) As CityCount > > From > > Cities > > Group By > > City > > You only have one of each ID in the database. You need to count what repeats. > > Try > > Select > > City, Count(City) As CityCount > > From > > Cities > > Group By > > City > > > -------------- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > --------- > | 1 | | > --------- Binary Soduko > | | | > --------- > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > Confidentiality Notice: This message including any > attachments is for the sole use of the intended > recipient(s) and may contain confidential and privileged > information. Any unauthorized review, use, disclosure or > distribution is prohibited. If you are not the > intended recipient, please contact the sender and > delete any copies of this message. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239057 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
