求按照部门进行分组之后,每个部门里面挣钱最多的那个人。
请问ORACLE 10g里连接连接条件里不能用等号(=)吗?
下面的查询语句错误在哪里?各位帮忙解答SQL> ed
已写入 file afiedt.buf 1 select ename ,sal ,deptno from emp
2 join (select max(sal) max_sal ,deptno from emp group by deptno) t
3* on (emp.sal = t.max_sal and emp.deptno = t.deptno) ;
SQL> /
on (emp.sal = t.max_sal and emp.deptno = t.deptno) ;
*
第 3 行出现错误:
ORA-00911: 无效字符
请问ORACLE 10g里连接连接条件里不能用等号(=)吗?
下面的查询语句错误在哪里?各位帮忙解答SQL> ed
已写入 file afiedt.buf 1 select ename ,sal ,deptno from emp
2 join (select max(sal) max_sal ,deptno from emp group by deptno) t
3* on (emp.sal = t.max_sal and emp.deptno = t.deptno) ;
SQL> /
on (emp.sal = t.max_sal and emp.deptno = t.deptno) ;
*
第 3 行出现错误:
ORA-00911: 无效字符
join (select max(sal) max_sal ,deptno from emp group by deptno) t
on emp.sal = t.max_sal and emp.deptno = t.deptno;
from emp
join (select max(sal) max_sal, deptno from emp group by deptno) t on (emp.sal =
t.max_sal and
emp.deptno =
t.deptno);
from emp
join (select max(sal) max_sal, deptno from emp group by deptno) t on (emp.sal =
t.max_sal and
emp.deptno =
t.deptno);
解决了!!!
SQL> select ename, sal,emp.deptno from emp
2 join (select max(sal) max_sal,deptno from emp group by deptno) t
3 on (emp.sal = t.max_sal and emp.deptno = t.deptno);ENAME SAL DEPTNO
---------- ---------- ----------
BLAKE 2850 30
SCOTT 3000 20
KING 5000 10
FORD 3000 20初学ORACLE!这个问题困扰了我一下午。
应该是原来那条select里和子查询里都有deptno字段,冲突了,在select里指明emp.deptno问题解决。
不知道我分析的准确不?
实践是检验真理的唯一标准.
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716