• Here's another method. This one adds an identity column, uses it, and then drops it.

    ALTER TABLE dbo.employee ADD tempid INT IDENTITY(1, 1)

    DELETE dbo.employee WHERE tempid NOT IN (SELECT MIN(tempid) FROM dbo.employee GROUP BY id, NAME, salary)

    ALTER TABLE dbo.employee DROP COLUMN tempid

    Ryan Randall

    Solutions are easy. Understanding the problem, now, that's the hard part.