MySql: Delete Duplicate Rows From Database

DELETE FROM table_name WHERE id IN (SELECT * FROM (SELECT MAX(id) FROM table_name WHERE `column_condition`='condition' GROUP BY column_name1, column_name2, column_name3 HAVING COUNT(*)> 1) AS A )

My Custom Module Example

DELETE FROM warranty WHERE warranty_id IN (SELECT * FROM (SELECT MAX(warranty_id) FROM warranty WHERE `warranty_type`=2 GROUP BY sticker_number, serial_number, qr_code HAVING COUNT(*)> 1) AS A )