Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Deleting Duplicate Records

    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...

Viewing post 1 (of 1 total)