SELECT
SUM(co)
FROM
(
SELECT
telephone,
count(telephone) AS co
FROM
noteaddress
GROUP BY
telephone
HAVING
count(telephone) > 1
) as a
guolsblog 2016-11-11 18:18 原文
SELECT
SUM(co)
FROM
(
SELECT
telephone,
count(telephone) AS co
FROM
noteaddress
GROUP BY
telephone
HAVING
count(telephone) > 1
) as a