Hi,
I am trying to assign "autonumber" for each line related to given
record.
TRANSACTION# DATE AMOUNT
3 01/01/05 100
3 01/01/05 150
3 01/01/05 50
4 02/05/05 1000
4 02/05/05 500
I would like to have another column LINE_NO
TRANSACTION# DATE AMOUNT LINE_NO
3 01/01/05 100 1
3 01/01/05 150 2
3 01/01/05 50 3
4 02/05/05 1000 1
4 02/05/05 500 2
Please help with query.
Thanks