考考你的SQL？我是做不出来。

[sqlquery]

DEPT updtime workernum
A 1996 00001
A 1996 00008
B 1996 10000
B 1996 10010
A 1997 04567
A 1997 04568
------------------------
DEPT updtime workernum ID
A 1996 00001 1
A 1996 00008 2
B 1996 10000 1
B 1996 10010 2
A 1997 04567 1
A 1997 04568 2

这个SQL怎么写？
----------------------------------------
按部门，然后按年编号，就是所这个部门的人，按年的顺序编号。

[liuyun2003]

思考中……

[txlicenhe]

http://expert.csdn.net/Expert/topic/2040/2040865.xml?temp=.8689997

[lovehwq21]

快说答案！

[yehuazi]

select DEPT, updtime,workernum,
ord = (select count(*)
from 表 as B
where B.dept = A.dept
and B.dept = A.dept
and B.workernum <= A.workernum)
from 表 as A
order by dept,updtime
记得下次给分.