MySQL查询只返回具有计数的重复条目

SELECT count(*), list_id, address_id
FROM lnk_lists_addresses
GROUP BY list_id, address_id
HAVING count(*)>1
ORDER BY count(*) DESC

把我的答案和托德的答案结合起来。运行的答案得到一个更“完整”的答案。您要使用HAVING子句:

http://dev.mysql.com/doc/refman/5.1/en/select.html

您想使用“having”子句。它的使用在mysql手册中进行了解释。

http://dev.mysql.com/doc/refman/5.1/en/select.html

SELECT count(*) AS total, list_id, address_id
FROM lnk_lists_addresses
WHERE total > 1
GROUP BY list_id, address_id
ORDER BY total DESC
LIMIT 20

如果命名count()字段,可以在语句的后面使用它。

编辑:忘记 HAVING (& gt;& & lt;)