How to delete duplicate records from a table ?

delete t1
from tblTable t1, tblTable t2
where t1.sName = t2.sName
and t1.uniqueField > t2.uniqueField

where t1.uniqueFiled should be int