select *, ( select count(*)

from addOrder counter

where counter.value <= addOrder.value) as rowNumber

from addOrder

--grouped

select *, ( select count(*)

from addOrder counter

where counter.groupNumber = addOrder.groupNumber

and counter.value <= addOrder.value) as rowNumber

from addOrder