在sql里查询平均中的最大值

select sno,avg(grade) as avgs
from stu_course
group by sno

查询平均结果后的最大值应该怎么用max

只要一个值：

select max(avgs) from (
select sno,avg(grade) as avgs
from stu_course
group by sno) t

保留平均值:

select sno,avg(grade) as avgs,
max(avg(grade)) over() maxs
from stu_course
group by sno

SELECT MAX(AVG) FROM (
select AVG(SAL) AVG
,MAX(SAL)MAX
,DEPTNO
FROM EMP
GROUP BY DEPTNO )