Hi, Please help
I'm trying to Delete Duplicate Records from my table I have this data

199 Name1 email1 add1
199 Name1 email1 add1
200 Name5 email5 add5
200 Name5 email5 add5
200 Name5 email5 add5
201 Name23 email23 add23

I want to delete the duplicate ones and keep only one of them that is what I want to keep

199 Name1 email1 add1
200 Name5 email5 add5
201 Name23 email23 add23

I'm using MS SQL

My table has more than 3500 Records
If you do not help I'll spend the rest of my life deleting the duplicate ones.