ID field, A field B, C, field D year


1, according to several fields of the same update sequence:

 update table set id=s_seq. Nextval where year=2021 group by field A, B, field C 

, 2 D to store the field A, B, C value, then the field D the same update into the same sequence


How do I write first, thank you,