Hello Guys

Here we are showing how to delete duplicate row from mysql database using join query

  DELETE t1 FROM ot_sub_district t1
INNER JOIN ot_sub_district t2 
WHERE 
     t1.sub_district_name = t2.sub_district_name;