This content has been marked as final. Show 3 replies
I have to go someplace in 5 mins, so I cannot answer your question completely, but I think I can get you 90% there...
select place1, place2, place3, place4
(select country as place1, state as place2, city as place3, town as place4, COUNT(*) as counter
GROUP BY country, state, city, town)
WHERE counter > 1
I think something like that is what you want. Gotta go, sorry.