-
下列代码块显示的查询包含一个子查询:
可以用下列哪个子句重新定义这个查询,删除子查询与主查询中组函数执行的重复?select dname, avg(sal) as dept_avg from emp, dept where emp.deptno = dept.deptno group by dname having avg(sal) > ( select avg(sal)*1/4 from emp,dept where emp.deptno = dept.deptno ) order by avg(sal);
A.group by B.order by C.with D.having
问题:上题中如何用with删除子查询与主查询中组函数执行的重复?