By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| RowNumber1 | GroupJobID | JobID | RowNumber2 |
|---|---|---|---|
| 1 | 6200 | A001 | 1 |
| 1 | 6200 | A002 | 2 |
| 2 | 6202 | A003 | 1 |
| 2 | 6202 | A004 | 2 |
| 2 | 6202 | A005 | 3 |
| 3 | 6201 | A006 | 1 |
| 3 | 6201 | A007 | 2 |
| 3 | 6201 | A008 | 3 |
| 3 | 6201 | A009 | 4 |
| 4 | 6202 | A010 | 1 |
| 5 | 6201 | A011 | 1 |