使用 COUNT 显示 MySQL 中出现次数超过 2 次的不同记录 [英] Use of COUNT to display distinct records with more than 2 occurrences in MySQL

问题描述

我有一个表，我试图在其中构建一个包含表中出现两次以上的所有城市的不同列表.我正在尝试当前查询时被告知函数计数不存在"?我做错了什么?

I have a table where I am trying to build a distinct list of all the cities with more than two occurrences in the table. I am trying the current query am am told "function count does not exist"? What am I doing wrong?

SELECT COUNT (city) 
FROM `table1` 
GROUP BY city 
HAVING COUNT (city) >=2

推荐答案

您的查询是正确的，您在 COUNT 和 (City) 之间留了一个空格，它必须是 COUNT(City).那会很好用.您的查询应如下所示:

Your query is correct you have given a space between COUNT and (City) it must be COUNT(City). that will work fine. Your query should be like this:

SELECT City, COUNT(city) Counts
  FROM `table1` 
 GROUP BY City
HAVING COUNT(city) >=2;

这篇关于使用 COUNT 显示 MySQL 中出现次数超过 2 次的不同记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！