I would like to return rows that have a different column value for a particular family of records. For instance, if I have a table consisting of State, Name, and Currency columns, and State is used to determine the family relationship. I only want to return values that have a different currency within the family (State).
Table name = Demo
State Name Currency NY Paul USD NY Tom CAD NY Nancy USD FLA Jason USD FLA Aimee USD CA Beth USD CA Jeremy USD
The result set I am looking for is
State Name Currency NY Paul USD NY Tom CAD NY Nancy USD
Hope this makes sense