如何寫查詢語句實現把排序查詢後的結果編號呢。

[fxjpost]

如 select id=(),a,b,sum(c) c from table
group by a,b
order by c
結果：id a b c
1 c b 2
2 d e 3
3 f g 5
4 5 4 4
5 f 4 6
.
.
.
n

[fxjpost]

補充：
注：不要用到臨時表的方法，就用查詢語句有沒有辦法

[pengdali]

select IDENTITY(int, 1,1) a,b,sum(c) c into #s from [table] group by a,b order by c
select * from #s

[txlicenhe]

除非你有关键字，比如是c

select id=(Select sum(1) from table where c<= aa.c),a,b,sum(c) c from table aa
group by a,b
order by c

[yujohny]

select identity(int,1,1) id,a,b,sum(c) c into #a from [table]
group by a,b order by c

select * from #a

[yujohny]

哦，回答时候还没看到你补充
你就要求C必须是主键，按马可的方法