I have a table with 4 columns,
itemcode (char(16)),
dattim(date time),
billamount(number(7,2)),
seqno(number(3).
all the columns are filled except seqno which has null values at present.
I have to fill the seqno column with 1,2,3,4,5,…… etc. for each itemcode in ascending order of dattim.
How can it be done through sql.
Any help is appreciated.