欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

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

程序员文章站 2023-12-27 23:12:51
...

union带有orderby的sql时,orderby需要放到子查询语法才有效 无 --union和order by连用需要放在子查询中,否则会报错--例如:--错误写法:select * from dept1 order by deptnounionselect * from dept2 order by deptno;--ORA-00933 "SQL command not proper

union带有order by的sql时,order by需要放到子查询语法才有效
--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);

上一篇:

下一篇: