union带有order by的sql时，order by需要放到子查询语法才有效

2015/09/02 41710

清华大佬耗费三个月吐血整理的几百G的资源，免费分享！....>>>

?
1
2
3
4
5
6
7
8
9
10
11
--union和order by连用需要放在子查询中，否则会报错
--例如：
--错误写法：
select * from dept1 order by deptno
union
select * from dept2 order by deptno;
--ORA-00933 "SQL command not properly ended"
--正确写法：
select * from (select * from dept1 order by deptno)
union
select * from (select * from dept2 order by deptno);