Remove duplicates using SQL
This is a way to remove duplicate rows in a database table using SQL. The column id is unique and the query choose to keep the latest id through this part of the query: `a`.`id` < `b`.`id` Further the column identifier is one duplicate column we use ti find the duplicates
DELETE `a` FROM `zimonitor_ahsay_api_queue` AS `a`, `zimonitor_ahsay_api_queue` AS `b` WHERE `a`.`id` < `b`.`id` AND (`a`.`identifier` = `b`.`identifier`);