Skip to content
Advertisement

How to delete all duplicate records from SQL Table?

Hello I have table name FriendsData that contains duplicate records as shown below

I want to remove duplicate combinations rows using MS SQL?
Remove latest duplicate records from MS SQL FriendsData table. here I attached image which highlights duplicate column combinations.

enter image description here

How I can removed all duplicate combinations from SQL table?

Advertisement

Answer

Try this

See here

Or here is more ways to do what you want

Hope this helps

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement