How to delete duplicate row from mysql database
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;
Share