We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Identify and remove duplicate locations. Here are two methods:
select name, city, count(*) from locations group by 1,2 having count(*) >1;
select street, state, count(*) from locations group by 1,2 having count(*) >1;
select lat, zip, count(*) from locations group by 1,2 having count(*) >1;