Delete duplicate row in MYSQL database example

To delete duplicate rows in MYSQL database, we can use below query:


DELETE n1 FROM TABLE_A n1, TABLE_B n2
         WHERE n1.id > n2.id AND n1.emp_code = n2.emp_code AND n1.attnd_date = n2.attnd_date
          AND n1.attnd_date>='2016-01-11' AND n1.attnd_date<='2016-01-20'