Delete Duplicate records From SQL -One Field Should be unique

Declare @T1 Table(Eid int,Ename varchar(10))


INSERT INTO @T1(Eid,EName)Values(1,'A')

INSERT INTO @T1(Eid,EName)Values(2,'A')

INSERT INTO @T1(Eid,EName)Values(3,'B')

INSERT INTO @T1(Eid,EName)Values(4,'B')

INSERT INTO @T1(Eid,EName)Values(5,'C')



DELETE FROM @T1 WHERE Eid NOT IN

(SELECT MAX(Eid) FROM @T1 GROUP BY Ename)

SELECT * from @T1