不好,我看了一下有好多是重複的數據,共有436條是重複的
-----------------------
SELECT AreaCode.AreaName
FROM AreaCode group by AreaName
having count(*)>1;
--------------------------
返回有436條
--------------------------
SELECT AreaCode.AreaName
FROM AreaCode group by AreaName
having count(*)=2;
---------------------------
返回有413條
--------------------------
SELECT AreaCode.AreaName
FROM AreaCode group by AreaName
having count(*)>=3;
---------------------------
返回有23條
---------------------------------------------------
不知 仙侣边缘人 老兄有沒有發現此問題