mysql - 仅选择与 MYSQL 匹配的邮政编码

Question

我试图仅显示表中多人拥有的邮政编码，并按升序对其进行排序。

我尝试了以下方法，但不起作用。

SELECT zipcode AS "zipcodes" FROM people GROUP BY zipcode ORDER BY ASC;

Answer 1

SELECT zipcode AS "zipcodes", count(1) as ZIP_COUNT
FROM people 
GROUP BY zipcode 
ORDER BY ZIP_COUNT ASC;

如果您只需要附加出现 2 次以上的邮政编码(在订单之前):

HAVING COUNT(1) > 1

或者(如果 Mysql 支持 HAVING 子句中的别名):

HAVING ZIP_COUNT > 1