SELECT
id,
count(*) AS count
FROM
mydata
WHERE
count > 1
GROUP BY
id
where用列别名来做查询条件出现报错
解决办法:
用了聚合函数group by,查询条件应该用having
SELECT
id,
count(*) AS count
FROM
mydata
GROUP BY
id
HAVING
count >1
SELECT
id,
count(*) AS count
FROM
mydata
WHERE
count > 1
GROUP BY
id
where用列别名来做查询条件出现报错
解决办法:
用了聚合函数group by,查询条件应该用having
SELECT
id,
count(*) AS count
FROM
mydata
GROUP BY
id
HAVING
count >1