> select sum(sal),count(empno) from emp where deptno=(select deptno from dept where dname like '%S%') group by deptno;
select deptno, sum(sal),count(empno) from emp group by deptno having deptno in (select deptno from dept where dname like '%S%');
2021-04-21
最新推荐文章于 2021-11-21 12:10:25 发布