select ename, sal,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)
/
deptno未能明确定义列select ename, sal 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)
/
就没问题 为什么deptno不能加上
join (select max(sal) max_sal, deptno from emp group by deptno) t
on(emp.sal=t.max_sal and emp.deptno=t.deptno)
/
deptno未能明确定义列select ename, sal 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)
/
就没问题 为什么deptno不能加上
select ename, sal,emp.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)
+10086 ticmy总是那么的给力