sparksql 求每个学生top3得分的数据

表准备

create table std(std_id int,course string,score double);

数据准备

insert into std values (1,'语文',98.5),(1,'数学',96),(1,'化学',80),(1,'生物',30),(2,'物理',20),(2,'政治',88),(3,'体育',66),(2,'音乐',77),(2,'英语',6);

sparksql

select * from (
     select std_id,course,score,row_number() over (partition by std_id order by score) as rank 
     from std) 
where rank<4;

结果：