摘要:
select b.dname,a.sal from (select deptno,sum(sal) sal from epm group by deptno ) a,(select deptno,dname) b where a.deptno=b.deptno order by 1,2;意思是根据第 阅读全文
摘要:
执行SQL> select ename,sum_sal from (select ename,sum(sal) sum_sal from ( select * from emp)) group by ename;select ename,sum_sal from (select ename,sum( 阅读全文