所以基本上emp表有emp(job,sal....)
我已经尝试了很多东西,包括min(avg(sal))
,但组合两个聚合函数是不可能的。尝试类似SELECT min(x.avg) FROM (SELECT AVG(sal)as avg FROM emp group by job)x;
的东西,它只会显示min(sal(,但我想显示作业。请帮助
您可以使用order by
和limit
。但至关重要的是,您需要选择job
!
SELECT job
FROM emp
GROUP BY job
ORDER BY AVG(sal)
LIMIT 1;
您只需要从Gordon的答案中选择一列-
SELECT job
FROM (SELECT job, AVG(sal)
FROM emp
GROUP BY job
ORDER BY AVG(sal)
LIMIT 1) T;