By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
XTypeNo | Xtype | Xvalue | Xmin | Xmax |
---|---|---|---|---|
1 | TypeA | 10 | 100 | 200 |
2 | TypeA | 20 | 100 | 200 |
3 | TypeA | 30 | 100 | 200 |
4 | TypeB | 410 | 200 | 300 |
5 | TypeB | 420 | 200 | 300 |
6 | TypeB | 430 | 200 | 300 |
7 | TypeC | 310 | 300 | 400 |
8 | TypeC | 320 | 300 | 400 |
9 | TypeC | 330 | 300 | 400 |
12 | TypeD | 410 | 400 | 500 |
13 | TypeD | 490 | 400 | 500 |
14 | TypeD | 550 | 400 | 500 |
15 | TypeE | 510 | 500 | 600 |
16 | TypeE | 590 | 500 | 600 |
17 | TypeE | 450 | 500 | 600 |
Xtype | XGROUP |
---|---|
TypeA | X1 |
TypeB | X3 |
TypeC | X2 |
Xtype | XGROUP |
---|---|
TypeA | X1 |
TypeB | X3 |
TypeC | X2 |
TypeD | X2 |
TypeD | X3 |
TypeE | X1 |
TypeE | X2 |
Msg 207 Level 16 State 1 Line 15
Invalid column name 'Nums'.