Viewing post 1 (of 1 total)
I'll typically use a DELETE FROM / GROUP BY combination in conjunction with a temporary table:
DELETE FROM employee
WHERE id NOT IN (
SELECT MIN(id)
FROM employee
GROUP BY name, salary
)
...assuming...
March 10, 2006 at 11:34 am
#626052