create table test(
                testA varchar(100),
                testB varchar(100),
                testC varchar(100)
         );
         insert into test values('A1','1001','1');
         insert into test values('A1','1002','1');
         insert into test values('A1','1003','1');
         insert into test values('A1','1004','1');
         
         insert into test values('A2','2001','3');
         insert into test values('A2','2002','3');
         insert into test values('A2','2003','3');
         insert into test values('A2','2004','3');