Hi Dinesh,
Please Try with Self Join Such as:
1. SELECT A.* FROM EmployeeList A
INNER JOIN Employeelist B ON
A.EmployeeId=B.EmployeeId AND A.city IN ('london','new york')
2.SELECT A.* FROM EmployeeList A
INNER JOIN Employeelist B ON
A.EmployeeId=B.EmployeeId AND (A.city ='london' OR A.city ='new york')
Ashish Nigam