select ZIP, count(distinct STATE) COUNT , STATE from DATA_TBL group by ZIP, STATE having count > 1;

closed as off-topic by Izzy Jun 28 at 21:35

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

  • wrong forum, try on stackoverflow. – ivanivan Jun 28 at 20:21

Browse other questions tagged or ask your own question.