MySQL -- 找出重複資料

SELECT a.ad13_area_code, a.ad13_city_name
FROM ad13 a, ad13 b
WHERE a.ad13_area_code = b.ad13_area_code
GROUP BY 1 , 2
HAVING count( a.ad13_area_code ) >1