By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| (No column name) |
|---|
| Microsoft SQL Server 2019 (RTM-CU3) (KB4538853) - 15.0.4023.6 (X64) Mar 4 2020 00:59:26 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor) |
| CUSTOMER_NO | STATUS | COUNTER | Needed |
|---|---|---|---|
| 1234 | A | 0 | 0 |
| 1234 | B | 0 | 0 |
| 1234 | C | 0 | 0 |
| 1234 | D | 1 | 1 |
| 1234 | D | 2 | 3 |
| 1234 | D | 3 | 6 |
| 1234 | C | 0 | 6 |
| 1234 | D | 1 | 7 |
| 1234 | D | 2 | 9 |
| 1234 | D | 3 | 12 |
| 1234 | D | 4 | 16 |