mexitek

-- DELETE duplicate entry
DELETE 
  FROM L_table
 WHERE id NOT IN (SELECT  MIN(id) id
               FROM L_table
              GROUP BY l_field, etc ASC);