TSQL Remove duplicated rows on some column only

Viewed 13201

Possible Duplicate:
SQL - How can I remove duplicate rows?

Example this is my table:

SiteKey, Name, City

The SiteKey is auto increament, Name is different , but some times 2 Sitekey will have same City.

Example:

1, A , CityA
2, B,  CityB
3, C,  CityA
4, D,  CityF

so I need to remove rows 3, and keep rows 1,2,4 only.

its on SQL 2005 and up.

thanks your help.

2 Answers
Related