![](https://static.youtibao.com/asksite/comm/h5/images/m_q_title.png)
[单选题]
查询出每个部门工资最低的员工的姓名、工作和工资,下列正确的语句是()
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
![](https://static.youtibao.com/asksite/comm/h5/images/m_q_a.png)
C、select ename,job,sal from emp where sal in(select min(sal) from emp group by deptno)
![](https://static.youtibao.com/asksite/comm/h5/images/solist_ts.png)