SELECT City, Count(City) As theCount FROM (Select City, State From tblCityStateZips Group By City, State) As C GROUP By City HAVING COUNT Count(City) > 1
Greenville 39 Greenwood 2 GreenBriar 3 etc.
选择计数/重复
SELECT City, Count(City) As theCount FROM (Select City, State From tblCityStateZips Group By City, State) As C GROUP By City HAVING COUNT Count(City) > 1
Greenville 39 Greenwood 2 GreenBriar 3 etc.