无条件查询出一组有规则的数据解决方法

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');