Subject Update with group by
Author Checkmail

Hello,

 

each record gets a barcode number (generated with a generator), everything is fine. But if the Position Number is the same, both records should get the same value. How can I realize this?

 

Update table a set field = gen_id(xxx,1) where field is not null group by pos?

 

Thanks.