; WITH EmployeesCTE
AS
(
	SELECT	ROW_NUMBER() OVER( PARTITION BY EmpID, EmpName ORDER BY EmpID ) AS RowNumber,
			EmpID, EmpName
	FROM	Employees
)
DELETE
FROM	EmployeesCTE
WHERE	RowNumber != 1

DECLARE @tbl TABLE
(
	EMPID			INT,
	EmpName			VARCHAR(100)
)

INSERT INTO @tbl
SELECT
1, 'aaa'
UNION ALL
SELECT
1, 'aaa'
UNION ALL
SELECT
2, 'aaa'
UNION ALL
SELECT
3, 'bbb'
UNION ALL
SELECT
2, 'bbb'



DELETE D FROM
(
SELECT
	ROW_NUMBER() OVER(PARTITION BY EMPID,EmpName ORDER BY EMPID) AS ROWS,
	EMPID,
	EmpName
FROM
	@tbl
)D
WHERE
	ROWS	> 1

SELECT * FROM @tbl