• 2022-06-07 问题

    列出薪水高于所在部门平均工资的员工信息() A: selectdeptno,ename,salfromempawheresal>(selectavg(a.sal)fromempwheredeptno=a.deptno); B: selectdeptno,ename,salfromempawheresal>(selectavg(sal)fromempwheredeptno=a.deptno); C: selecta.deptno,a.ename,a.salfromempa,empbwherea.deptno=b.deptnoanda.sal>avg(b.sal); D: selecta.deptno,a.ename,a.salfromempa,empbwherea.deptno=b.deptnoandb.sal>avg(a.sal);

    列出薪水高于所在部门平均工资的员工信息() A: selectdeptno,ename,salfromempawheresal>(selectavg(a.sal)fromempwheredeptno=a.deptno); B: selectdeptno,ename,salfromempawheresal>(selectavg(sal)fromempwheredeptno=a.deptno); C: selecta.deptno,a.ename,a.salfromempa,empbwherea.deptno=b.deptnoanda.sal>avg(b.sal); D: selecta.deptno,a.ename,a.salfromempa,empbwherea.deptno=b.deptnoandb.sal>avg(a.sal);

  • 1