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.