Category Archives: MS SQL Server 2000

How to identify and delete duplicate records from sql table

March 16, 2009 – 12:12 am

Well I’m sure any SQL developer out there would have encountered a problem where the duplicate records in a table have to eliminated for some reasons.
I recently encountered a similar situation where I had to remove the duplicate user name from a table with just one simple query . Here is how I did it:
Here [...]

By toalakan-web | Also posted in MS SQL Server, Personal | Tagged , , | Comments (1)