准备数据:
CREATE TABLE TEST_GROUP_A (
STDCODE VARCHAR2(30),
DEMO VARCHAR2(100)
);
insert into TEST_GROUP_A values ('1001','AAA');
insert into TEST_GROUP_A values ('1001','BBB');
insert into TEST_GROUP_A values ('1002','CCC');
insert into TEST_GROUP_A values ('1001','AGE');