SQL> select * from ry; BH MC RYDW DJBH
---------- ---------- ---------- ----------
1 aaa 0 906
2 bbb 1 906
1 aaa 1 1004
2 bbb 0 1004
3 ccc 0 1000
4 ddd 1 1000
5 eee 0 1001已选择7行。SQL> select t.* from (
2 select a.bh bha,b.bh bhb,a.djbh from
3 (select * from ry where rydw=0) a,(select * from ry where rydw=1) b
4 where a.djbh=b.djbh) t,
5 (select b.bh bha,a.bh bhb,a.djbh from
6 (select * from ry where rydw=0) a,(select * from ry where rydw=1) b
7 where a.djbh=b.djbh) tt
8 where t.bha=tt.bha and t.bhb=tt.bhb; BHA BHB DJBH
---------- ---------- ----------
1 2 906
2 1 1004
SQL> insert into ry values(4,'ddd',0,999);已创建 1 行。SQL> insert into ry values(3,'ccc',1,999);已创建 1 行。SQL> select * from ry; BH MC RYDW DJBH
---------- ---------- ---------- ----------
1 aaa 0 906
2 bbb 1 906
1 aaa 1 1004
2 bbb 0 1004
3 ccc 0 1000
4 ddd 1 1000
5 eee 0 1001
4 ddd 0 999
3 ccc 1 999已选择9行。SQL> select t.* from (
2 select a.bh bha,b.bh bhb,a.djbh from
3 (select * from ry where rydw=0) a,(select * from ry where rydw=1) b
4 where a.djbh=b.djbh) t,
5 (select b.bh bha,a.bh bhb,a.djbh from
6 (select * from ry where rydw=0) a,(select * from ry where rydw=1) b
7 where a.djbh=b.djbh) tt
8 where t.bha=tt.bha and t.bhb=tt.bhb; BHA BHB DJBH
---------- ---------- ----------
1 2 906
2 1 1004
3 4 1000
4 3 999SQL>
---------- ---------- ---------- ----------
1 aaa 0 906
2 bbb 1 906
1 aaa 1 1004
2 bbb 0 1004
3 ccc 0 1000
4 ddd 1 1000
5 eee 0 1001已选择7行。SQL> select t.* from (
2 select a.bh bha,b.bh bhb,a.djbh from
3 (select * from ry where rydw=0) a,(select * from ry where rydw=1) b
4 where a.djbh=b.djbh) t,
5 (select b.bh bha,a.bh bhb,a.djbh from
6 (select * from ry where rydw=0) a,(select * from ry where rydw=1) b
7 where a.djbh=b.djbh) tt
8 where t.bha=tt.bha and t.bhb=tt.bhb; BHA BHB DJBH
---------- ---------- ----------
1 2 906
2 1 1004
SQL> insert into ry values(4,'ddd',0,999);已创建 1 行。SQL> insert into ry values(3,'ccc',1,999);已创建 1 行。SQL> select * from ry; BH MC RYDW DJBH
---------- ---------- ---------- ----------
1 aaa 0 906
2 bbb 1 906
1 aaa 1 1004
2 bbb 0 1004
3 ccc 0 1000
4 ddd 1 1000
5 eee 0 1001
4 ddd 0 999
3 ccc 1 999已选择9行。SQL> select t.* from (
2 select a.bh bha,b.bh bhb,a.djbh from
3 (select * from ry where rydw=0) a,(select * from ry where rydw=1) b
4 where a.djbh=b.djbh) t,
5 (select b.bh bha,a.bh bhb,a.djbh from
6 (select * from ry where rydw=0) a,(select * from ry where rydw=1) b
7 where a.djbh=b.djbh) tt
8 where t.bha=tt.bha and t.bhb=tt.bhb; BHA BHB DJBH
---------- ---------- ----------
1 2 906
2 1 1004
3 4 1000
4 3 999SQL>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货