Find records with same city and salary

Question

This is my query for finding matching records, but same salary condition is not working.

I want multiple same city and same salary records

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

Don't tag products not involved. I suppose you can remove at least some of your tags... — jarlh, Feb 19 '16 at 07:37
Why MySQL, SQL Server and Oracle? Tag only those products which you are using! — Rahul Tripathi, Feb 19 '16 at 07:37
Add sample table data, and the expected result. And table definitions. — jarlh, Feb 19 '16 at 07:37
You should avoid ancient-style joining by `,` - write what exactly you want from server: inner, outer, cross, full join and it's conditions. — Ivan Starostin, Feb 19 '16 at 07:40
Can you specify your server first? which out one of three mentioned? — Ivan Starostin, Feb 19 '16 at 09:13
Possible duplicate of [How to find The Same City and same salary record](http://stackoverflow.com/questions/35553882/how-to-find-the-same-city-and-same-salary-record) — Ralph, Feb 22 '16 at 13:53

score 0 · Answer 1 · answered Feb 19 '16 at 07:41

0

t1.Salary<>t2.Salary should be t1.Salary = t2.Salary

to solve this "But Same Salary Condition Not Working"

answered Feb 19 '16 at 07:41

Marco Bong

690
4
13

Find records with same city and salary

1 Answers1