Subject Update with group by
Author Checkmail



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?