表数据
SQL> select*fromt2;
ID1ID2ID3
---------- ---------- ----------
1
3100
4
5100
6
6150
7
8100
9 10100
达到结果为
1 5 100
6 6 150
710 100
注意结果这里第1,3行是分开的不能合并在一条上
create table t2
(id1 number(10),id2 number(10),id3 number(10));
insert into t2values(1,3,100);
insert into t2values(4,5,100);
insert into t2values(6,6,150);
insert into t2values(7,8,100);
insert into t2values(9,10,100);
|