--OR!!

declare @affected tinyint

SET @affected = 1

SET ROWCOUNT 1

WHILE @affected > 0

BEGIN

DELETE employee

FROMemployee

INNER JOIN

(

SELECT id, name, salary

FROM employee

GROUP BY id, name,salary

HAVING COUNT(1)>1

) dupes

ONdupes.id = employee.id

ANDdupes.name = employee.name

ANDdupes.salary = employee.salary

SET @affected = @@ROWCOUNT

END

SET ROWCOUNT 0

SELECT * FROM employee

ORDER BY id

DROP TABLE employee