I have table Example, that contain column name ID, OrgName, Address, WS
ID OrgName Address WS
1 ABC sa a
2 TATA ss b
3 MRF dsds c
4 MRF abfd d
5 TVS ggg e
Now i want to delete those row which contain duplicate OrgName, Means i want to check only OrgName Column and not whole row.
I want this table like this
ID OrgName Address WS
1 ABC sa a
2 TATA ss b
3 MRF dsds c
5 TVS ggg e