Tuesday, January 10, 2012

Find duplicate rows in a table

select city_name
from areas
group by city_name
having count(*) > 1

No comments: