无条件查询出一组有规则的数据
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');