By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
cola | colb | col_new_id |
---|---|---|
id1 | a | 1 |
id1 | b | 1 |
id2 | c | 1 |
id2 | d | 1 |
id3 | e | 2 |
id3 | f | 2 |
id4 | g | 2 |
id4 | h | 2 |
8 rows affected
cola | colb | col_new_id |
---|---|---|
id1 | a | 1 |
id1 | b | 1 |
id2 | c | 1 |
id2 | d | 1 |
id3 | e | 2 |
id3 | f | 2 |
id4 | g | 2 |
id4 | h | 2 |