How delete dublicate records in mysql table?

Find the following code using this code we can delete duplicate records

If you want to delete total dublicate records write check with the below code

delete from emp_sal USING emp_sal, emp_sal as vtable WHERE (NOT emp_sal.id=vtable.id) AND (emp_sal.sal=vtable.sal)

If you want to delete more one dublicate records check the below code

delete from emp_sal USING emp_sal, emp_sal as vtable WHERE emp_sal.id > vtable.id AND (emp_sal.sal=vtable.sal)