表A id cplbmc point 1 aaa 3 2 bbb 6 3 ccc 5 4 ddd 4表B id clyqmc point 1 aa 7 2 bb 2 3 cc 8我想要得到下表的结果,请问各位oracle怎么写呀,很急,下线等了,万分感谢 id mc point 3 cc 8 1 aa 7 2 bbb 6 3 ccc 5 4 ddd 4 1 aaa 3 2 bb 2
select * from (select id,cplbmc as mc, point from A union all select id,clyqmc as mc, point from B) order by point desc
create table A ( id int, cplbmc varchar(20), point number ) insert into A values(1,'aaa',3); insert into A values(2,'bbb',6); insert into A values(3,'ccc',5); insert into A values(4,'ddd',4); create table B ( id int, clyqmc varchar(20), point number ) insert into B values(1,'aa',7); insert into B values(2,'bb',2); insert into B values(3,'aa',8);--查询 select * from (select * from A union select * from B )v order by v.point desc
(
id int,
cplbmc varchar(20),
point number
)
insert into A values(1,'aaa',3);
insert into A values(2,'bbb',6);
insert into A values(3,'ccc',5);
insert into A values(4,'ddd',4);
create table B
(
id int,
clyqmc varchar(20),
point number
)
insert into B values(1,'aa',7);
insert into B values(2,'bb',2);
insert into B values(3,'aa',8);--查询
select * from
(select * from A
union
select * from B )v
order by v.point desc