February 5th, 2013, 08:00 AM
Help finding more than 1 occurrence in a table
Hello! I need help finding cities with more than 1 postal code.
Thanks a lot!
February 5th, 2013, 12:37 PM
HAVING COUNT(*) > 1
February 7th, 2013, 07:28 AM
aaaack! slight correction....
this is assuming, of course, that the column named "postalcodes" actually has only one postalcode in each value (instead of, say, a comma-delimited list of postalcodes)
HAVING COUNT(DISTINCT postalcodes) > 1