SQL Server 2017

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