17,086
社区成员
发帖
与我相关
我的任务
分享
SQL> select * from dept a
2 where a.deptno in
3 (
4 select b.deptno from dept b
5 order by b.dname
6 )
7 ;
order by b.dname
*
ERROR at line 5:
ORA-00907: missing right parenthesis
--单独执行是可以的
SQL> select b.deptno from dept b
2 order by b.dname;
DEPTNO
----------
10
40
20
30
SQL>