很难的一个sql,想了半个下午:(

[laughsmile]

code value
0001 3000
0002 5000
0004 3100
0001 3000
0001 5000
0001 3000
0003 5000
希望以value字段为计数,显示value字段出现的顺序数
name money counts
0001 3000 1
0002 5000 1
0004 3100 1
0001 3000 2
0001 5000 2
0001 3000 3
0003 5000 3

[huangjianyou]

SQL还很笨，遇到这样的问题我都会在编写程序时用过程表解决。

^_^

[bl_xin]

这样做有什么意义呢?一次统计出相同个数不行?

[rea1gz]

select identity(int,1,1) as id,* into #t from tablename

select code as name,value as money,
(select count(*) from #t where code=a.code and value=a.value and id<=a.id) as counts
from #t a
order by id

drop table #t

[phantomMan]

如果表还有一个自增字段,可以达到要求,假如没有,不知道怎么办,或许用临时表加入自增字段也可以实现

[laughsmile]

Thank you, rea1gz,You are so smart,and you will not need to be fake realgz.
appreciate for your help