SELECT
SUM(co)
FROM
(
SELECT
telephone,
count(telephone) AS co
FROM
noteaddress
GROUP BY
telephone
HAVING
count(telephone) > 1
) as a
原文：http://www.cnblogs.com/guolsblog/p/6055261.html