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`);
Knowledge keywords: