显示最高和最低值Sqlplus

Question

我是SqlPlus的新手，我试图显示所有部门中最高和最低的平均工资。到目前为止，我只能显示最高的薪水，但我似乎无法显示最低的薪水。

这是我走到这一步，

SELECT deptno AS "Dept. No", MAX(sal) AS "Salary" 
FROM emp e 
WHERE e.sal > (SELECT avg(sal) FROM emp) 
GROUP BY deptno; 

我得到的输出是

Dept. No Salary 
30   2850 
20   3000 
10   5000 

我试图让

Dept. No Salary 
30   2850 
30   950 
20   3000 
20   800 
10   5000 
10   1300 

哦，我现在用的是部门和emp表格样本！

Answer 1

如果有其他人有同样的问题，此查询适用于我！ :)

SELECT deptno AS "Dept. No", MAX(sal) AS "Highest Salary", MIN(sal) AS "Lowest Salary" 
FROM emp 
GROUP BY deptno;