Subject | Update with group by |
---|---|
Author | Checkmail |
Post date | 2016-04-14T15:46:03Z |
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.