题解 | 考试分数(二)
考试分数(二)
https://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select id,job,score from (select *, avg(score) over (partition by job ) as avg from grade )as a where score>avg order by id
取出高于平均分的人的信息,使用窗口函数
考试分数(二)
https://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select id,job,score from (select *, avg(score) over (partition by job ) as avg from grade )as a where score>avg order by id
取出高于平均分的人的信息,使用窗口函数
相关推荐