By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
(No column name) |
---|
Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor) |
4 rows affected
id | value |
---|---|
1 | PARAM1 |
1 | PARAM2 |
1 | PARAM4 |
1 | PARAM6 |
2 | PARAM1 |
2 | PARAM2 |
2 | PARAM3 |
2 | PARAM5 |
3 | PARAM3 |
3 | PARAM5 |
3 | PARAM6 |
3 | PARAM7 |
4 | PARAM1 |
4 | PARAM3 |
4 | PARAM4 |
4 | PARAM6 |
id | num_matches |
---|---|
2 | 2 |
3 | 2 |
4 | 2 |
id | num_matches |
---|---|
2 | 2 |
3 | 2 |
4 | 2 |