求分组后有自动分组序号的写法

[gos_q]

有如下表

类型 数量
B 3
A 2
C 6
B 4

希望得到如下结果

序号 类型 数量
1 A 2
2 B 7
3 C 6

我不知这个序号要怎样才可以select出来，大家帮下忙可以吗？

[gos_q]

谢谢两位,现在结贴.

[marco08]

create table T(type varchar(10), num int)
insert T select 'B', 3
union all select 'A', 2
union all select 'C', 6
union all select 'B', 4

select ID=identity(int, 1, 1), type, num=sum(num)
into #T
from T
group by type
order by type

select * from #T

--result
ID type num
----------- ---------- -----------
1 A 2
2 B 7
3 C 6

(3 row(s) affected)

[caixia615]

declare @a table(a char(10),b int)
insert into @a select 'B',3
union all select 'A',2
union all select 'C',6
union all select 'B',4

select c=(select count(*) from (select distinct a from @a) a where b.a>=a.a ),a ,sum(B)AS B FROM @A b group by a
result:
c a B
----------- ---------- -----------
1 A 2
2 B 7
3 C 6

（所影响的行数为 3 行）

[marco08]

create table T(type varchar(10), num int)
insert T select 'B', 3
union all select 'A', 2
union all select 'C', 6
union all select 'B', 4

select ID=(select count(distinct type)+1 from T where type<tmp.type), type, num=sum(num)
from T as tmp
group by type
order by type

--result
ID type num
----------- ---------- -----------
1 A 2
2 B 7
3 C 6

(3 row(s) affected)

[marco08]

create table T(type varchar(10), num int)
insert T select 'B', 3
union all select 'A', 2
union all select 'C', 6
union all select 'B', 4

select ID=(select count(distinct type) from T where type<=tmp.type), type, num=sum(num)
from T as tmp
group by type
order by type

--result
ID type num
----------- ---------- -----------
1 A 2
2 B 7
3 C 6

(3 row(s) affected)