How do I get the ID column (& other columns) that do not have the same value in the city column?-CodePudding

Home > Software design > How do I get the ID column (& other columns) that do not have the same value in the city column?

How do I get the ID column (& other columns) that do not have the same value in the city column?

Time：12-15

Let's say I have this:

Here count(*) over win != countif(city = 'Miami') over win is literally translated as where all city values for the same id is NOT Miami