add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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
18 TypeD 505 400 500
19 TypeD 506 400 500
20 TypeF 590 500 600
21 TypeF 450 500 600
22 TypeG 450 600 700
23 TypeG 460 600 700
24 TypeG 470 600 700
25 TypeG 650 600 700
26 TypeG 660 600 700
27 TypeG 850 600 700
28 TypeG 860 600 700
29 TypeG 870 600 700
30 TypeH null null null
Xtype X1 X2 X3 XGROUP_NEW
TypeA 3 0 0 X1
TypeB 0 0 3 X3
TypeC 0 3 0 X2
TypeD 0 2 3 X3
TypeE 1 2 0 X1
TypeF 1 1 0 X1
TypeG 3 2 3 X3
TypeH 0 0 0 null