Actual
deptid. product id. part no Sortnumber
10 100 123
10 100 234
——————————-—
10 200 456
10 200 234
———-
20 100 234
20 200 456
assign sort number from 610 with increments 10 with group of combination dept id and product id
Order by partnuber . How can i update sort number to get expected output below
Expected output
deptid. product id. part no Sortnumber
10 100 123 610
10 100 234 620
——————————-—
10 200 234 610
10 200 456 620
———-
20 100 234 610
———
20 200 456 610