February 5th, 2013, 09: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, 01:37 PM
HAVING COUNT(*) > 1
February 7th, 2013, 08: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