SQL语句：用count求group by分组的个数

select
count(*)
num,sid
into
#a
from
person
group
by
sid
select
count(*)
from
#a
或者
select
count(*)
from
(select
count(*)
num,sid
from
person
group
by
sid
)