oracle keep

创建测试数据：

create table test(
id     number,
a      number,
b      number
);

insert into test values (1,111,1 );
insert into test values (1,222,1 );
insert into test values (1,333,1 );
insert into test values (1,555,3 );
insert into test values (1,666,3 );
insert into test values (2,111,1 );
insert into test values (2,222,1 );
insert into test values (2,333,2 );
insert into test values (2,555,2 );
commit;

oracle keep

标签：