Remove Duplicate from sql table

Select fielddefid ,Fieldname from fielddefs group by fielddefid,fieldname having count(fielddefid) > 1

Comments