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

Question

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

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

Answer 1

只要一个值：

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