Mr_Shaw
asked on
Is there a way in which I can remove duplicates in SQL 2005?
Is there a way in which I can remove duplicates in SQL 2005?
Each row as a unique primary ID, however there are duplicate values in other rows. Example,
ID City
1 London
2 London
3 Wales
Each row as a unique primary ID, however there are duplicate values in other rows. Example,
ID City
1 London
2 London
3 Wales
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER