mysql - 我可以将结果限制为 sql 中的特定数字吗？

Question

Select count(*) as c from casting where ord = 1 Group by actorid Order by count(*) DESC 

结果是
15 15 14 13 12 10 7 7 7 7 5 5

那我想得到的结果只大于10 ??怎么办谢谢~~

Answer 1

SELECT count(*) AS c 
FROM casting 
WHERE ord = 1 
GROUP BY actorid 
HAVING c > 10
ORDER BY c DESC

可以考虑HAVING GROUP BY 聚合的 WHERE 子句。