分组查询 筛选出 count(number) >= 3的 然后输出
select number from
(select number, count(number) c_n
from grade
group by number
having c_n>=3) t;
分组查询 筛选出 count(number) >= 3的 然后输出
select number from
(select number, count(number) c_n
from grade
group by number
having c_n>=3) t;