running numbers in Select statement- Help?

[saroren]

I am trying to get running numbers in Select statment.

1 job1
2 job2
3 job3
4 job4


I tried sql like this

select num = (select count(*) from pub.ws_det b where b.ws_nbr <= a.ws_nbr) ,
a.ws_nbr
from pub.ws_det a

Also i tried

select (select count(*) from pub.ws_det b where b.ws_nbr <= a.ws_nbr) as num ,
a.ws_nbr
from pub.ws_det a



but gives syntax error (7587)


Please help!!!!