求每次考试的最高分、最低分
first_value
last_value
select
dt,
first_value(score) over(distribute by dt sort by score desc) as maxscore,
last_value(score) over(distribute by dt sort by score desc) as minscore
from stu_score
;
排名函数:
row_number:没有并列,相同名次顺序排
rank:有并列,相同名次空位
dense_rank:有并列,相同名次无空位