insert into cselect
a.id,a.name,a.age,a.fen,a.class
from a
order by a.id,a.class
union
select
b.id,b.name,b.age,b.fen,b.class
from b
order by b.id,b.class报错sql 命令尚未正确结束大家看看拿写错了 谢谢
a.id,a.name,a.age,a.fen,a.class
from a
order by a.id,a.class
union
select
b.id,b.name,b.age,b.fen,b.class
from b
order by b.id,b.class报错sql 命令尚未正确结束大家看看拿写错了 谢谢
insert into c
select
a.id,a.name,a.age,a.fen,a.class
from a
union
select
b.id,b.name,b.age,b.fen,b.class
from b;
我想 带 order by
oracle插入数据的顺序是不固定的,order by只给查询起作用。原因解释给你了,如果你非得想加,去掉你代码的第一个order by 只留第二个。