create table test(clothid varchar(10),number varchar(10),bagid varchar(10))
insert into test
select '11-11','56','1'
union all select '11-12-1','45','1'
union all select '11-12-2','46','1'
union all select '11-12-3','50','2'
union all select '11-13-1','60','2'
union all select '11-13-2','32','2'
union all select '11-14','34','3'
union all select '11-15-1','45','3'
union all select '11-15-2','52','3'