sql server Same City and same Salary record Finding : 
This is my Qurey for finding matching Record But Same Salary Condition Not Working
i i want Multiple  Same City And Multiple Same Salary Record

select distinct t1.Name,t1.Salary,t1.City from Test t1  ,  test t2 
where
 t1.City=t2.City and t1.Salary<>t2.Salary