select left(课程代号,1) as 学期, count(*) as 人数 from @t where left(课程代号,1)=值 group by left(课程代号,1)--or select top 1 left(课程代号,1) as 学期, count(*) as 人数 from @t group by left(课程代号,1)--or select top 1 left(课程代号,1) as 学期, count(*) as 人数 from @t group by left(课程代号,1) order by left(课程代号,1) desc
count(*) as 人数
from
@t
where left(课程代号,1)=值
group by left(课程代号,1)--or
select top 1 left(课程代号,1) as 学期,
count(*) as 人数
from
@t
group by left(课程代号,1)--or
select top 1 left(课程代号,1) as 学期,
count(*) as 人数
from
@t
group by left(课程代号,1)
order by left(课程代号,1) desc