16.列出各种工作的最低工资及从事此工作的雇员姓名
确定所需要的数据表:
emp表:最低工资,雇员名称
16.1 各种工作的最低工资
SELECT MIN(e.sal) minsal,e.job job FROM emp e GROUP BY e.job;
16.2 从事此工作的雇员姓名
SELECT e.ename ,temp.job,temp.minsal FROM emp e ,
(SELECT MIN(e.sal) minsal,e.job job FROM emp e GROUP BY e.job) temp
WHERE e.sal IN temp.minsal;
SELECT e.ename ,e.job,e.sal FROM emp e ,
(SELECT job,MIN(sal) min FROM emp GROUP BY job) temp
WHERE e.job=temp.job AND e.sal=temp.min;