34,837
社区成员




select grade,classnum=count(distinct classid),nums=count(id) from #a group by grade
create table #a (id varchar(10),grade int,classid int)
insert into #a values('ws',2007,1)
insert into #a values('aa',2007,2)
insert into #a values('bb',2007,1)
insert into #a values('cc',2008,1)
select grade,classnum=count(distinct classid),nums=count(id) from #a group by grade
grade classnum nums
----------- ----------- -----------
2007 2 3
2008 1 1
(2 行受影响)
select grade, classnum=count(distinct classid), nums=count(1)
from A表
group by grade