1 月
23
2006

Memo : 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

Related Posts

About the Author: 阿維

阿維雜記本的偷懶維護者

Comments are closed.