题目内容
(请给出正确答案)
[单选题]
查询出每个部门工资最低的员工的姓名、工作和工资,下列正确的语句是()
A.select ename,job,sal from emp where sal in(select avg(sal) from emp group by deptno)
B.select ename,job,sal from emp where sal in(select min(sal) from emp order by deptno)
C.select ename,job,sal from emp where sal in(select min(sal) from emp group by deptno)
D.select ename,job,min(sal) from emp where sal group by deptno
答案
C、select ename,job,sal from emp where sal in(select min(sal) from emp group by deptno)
如果结果不匹配,请 联系老师 获取答案