在SQL中怎么对一个数据统计排查出去单个数据大于10的？

select color_no,count(*) as 出现次数 from dbo.Yarn_Out

WHERE COLOR_NO like '%E%' and COLOR_NO not like '%E'

group by color_no

having count(*)>10

order by color_no

having用于组内筛选，筛选出数量（count）大于10的数据

select cname,course.cno,count(*) 不及格人数

from course join sc on course.cno=sc.cno

where grade<60

group by cname,course.cno

having count(*)>10

---