DECLARE @tbl TABLE

(

EMPIDINT,

EmpNameVARCHAR(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