Find More Than one records in a Table

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


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

INSERT INTO @T1(Eid,EName,Loc)Values(2,'B','Delhi')

INSERT INTO @T1(Eid,EName,Loc)Values(3,'C','Delhi')

INSERT INTO @T1(Eid,EName,Loc)Values(4,'D','KOL')

INSERT INTO @T1(Eid,EName,Loc)Values(5,'E','MUM')

INSERT INTO @T1(Eid,EName,Loc)Values(6,'F','MUM')

INSERT INTO @T1(Eid,EName,Loc)Values(7,'G','MUM')

INSERT INTO @T1(Eid,EName,Loc)Values(8,'H','Lko')





SELECT EId, EName from @T1 where Loc IN (

SELECT Loc FROM @T1 GROUP BY Loc

HAVING COUNT(*) > 1)