By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| ACCT_NBR | COUNTER_1 | COUNTER_2 | COUNTER_3 |
|---|---|---|---|
| 1234 | 1 | 1 | 1 |
| 5678 | 1 | 0 | 1 |
| 9876 | 0 | 0 | 1 |
| 4567 | 1 | 0 | 0 |
| 2804 | 0 | 1 | 1 |
8 rows affected
| ACCT_NBR | COUNTER_1 | COUNTER_2 | COUNTER_3 |
|---|---|---|---|
| 1234 | 1 | 1 | 1 |
| 5678 | 1 | 0 | 1 |
| 9876 | 0 | 0 | 1 |
| 4567 | 1 | 0 | 0 |
| 2804 | 0 | 1 | 1 |