Here is a working query that finds all rows in my table that have duplicate City and State fields.
FROM CityLIst AS a INNER JOIN
(SELECT City, State
GROUP BY City, State
HAVING (COUNT(*) > 1)) AS b ON a.City = b.City AND a.State = b.State
It is returning about 100 instances in my table of duplicates. Now I want to be able to delete rows...but in my SQL Management Studio the whole table is grayed out, It wont let me delete any of the results. Does someone know an easy way I can delete records? I only want one instance of any row with a particular City, State.