日期:2014-05-17 浏览次数:20732 次
select e.deptno, d.dname, sum(e.sal) from emp e join dept d on e.deptno = d.deptno group by e.deptno,dname; select e.deptno, d.dname, sum(e.sal) from emp e , dept d where e.deptno = d.deptno group by e.deptno,dname;