By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| (No column name) |
|---|
| Microsoft SQL Server 2019 (RTM-CU16) (KB5011644) - 15.0.4223.1 (X64) Apr 11 2022 16:24:07 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor) |
| Col1 | Col2 | Factor | Series |
|---|---|---|---|
| A | B | 50 | 1 |
| A | B | 50 | 2 |
| A | B | 50 | 3 |
| A | B | 50 | 4 |
| A | B | 50 | 5 |
| A | B | 50 | 6 |
| A | B | 50 | 7 |
| A | B | 50 | 8 |
| A | B | 50 | 9 |
| A | B | 50 | 10 |
| A | B | 50 | 11 |
| A | B | 50 | 12 |
| A | B | 50 | 13 |
| A | B | 50 | 14 |
| A | B | 50 | 15 |
| A | B | 50 | 16 |
| A | B | 50 | 17 |
| A | B | 50 | 18 |
| A | B | 50 | 19 |
| A | B | 50 | 20 |
| A | B | 50 | 21 |
| A | B | 50 | 22 |
| A | B | 50 | 23 |
| A | B | 50 | 24 |
| A | B | 50 | 25 |
| A | B | 50 | 26 |
| A | B | 50 | 27 |
| A | B | 50 | 28 |
| A | B | 50 | 29 |
| A | B | 50 | 30 |
| A | B | 50 | 31 |
| A | B | 50 | 32 |
| A | B | 50 | 33 |
| A | B | 50 | 34 |
| A | B | 50 | 35 |
| A | B | 50 | 36 |
| A | B | 50 | 37 |
| A | B | 50 | 38 |
| A | B | 50 | 39 |
| A | B | 50 | 40 |
| A | B | 50 | 41 |
| A | B | 50 | 42 |
| A | B | 50 | 43 |
| A | B | 50 | 44 |
| A | B | 50 | 45 |
| A | B | 50 | 46 |
| A | B | 50 | 47 |
| A | B | 50 | 48 |
| A | B | 50 | 49 |
| A | B | 50 | 50 |
| C | D | 60 | 1 |
| C | D | 60 | 2 |
| C | D | 60 | 3 |
| C | D | 60 | 4 |
| C | D | 60 | 5 |
| C | D | 60 | 6 |
| C | D | 60 | 7 |
| C | D | 60 | 8 |
| C | D | 60 | 9 |
| C | D | 60 | 10 |
| C | D | 60 | 11 |
| C | D | 60 | 12 |
| C | D | 60 | 13 |
| C | D | 60 | 14 |
| C | D | 60 | 15 |
| C | D | 60 | 16 |
| C | D | 60 | 17 |
| C | D | 60 | 18 |
| C | D | 60 | 19 |
| C | D | 60 | 20 |
| C | D | 60 | 21 |
| C | D | 60 | 22 |
| C | D | 60 | 23 |
| C | D | 60 | 24 |
| C | D | 60 | 25 |
| C | D | 60 | 26 |
| C | D | 60 | 27 |
| C | D | 60 | 28 |
| C | D | 60 | 29 |
| C | D | 60 | 30 |
| C | D | 60 | 31 |
| C | D | 60 | 32 |
| C | D | 60 | 33 |
| C | D | 60 | 34 |
| C | D | 60 | 35 |
| C | D | 60 | 36 |
| C | D | 60 | 37 |
| C | D | 60 | 38 |
| C | D | 60 | 39 |
| C | D | 60 | 40 |
| C | D | 60 | 41 |
| C | D | 60 | 42 |
| C | D | 60 | 43 |
| C | D | 60 | 44 |
| C | D | 60 | 45 |
| C | D | 60 | 46 |
| C | D | 60 | 47 |
| C | D | 60 | 48 |
| C | D | 60 | 49 |
| C | D | 60 | 50 |
| C | D | 60 | 51 |
| C | D | 60 | 52 |
| C | D | 60 | 53 |
| C | D | 60 | 54 |
| C | D | 60 | 55 |
| C | D | 60 | 56 |
| C | D | 60 | 57 |
| C | D | 60 | 58 |
| C | D | 60 | 59 |
| C | D | 60 | 60 |