【SQL练习题】以班级分组，按语文成绩，英语成绩，数学成绩进行排名

题目如下：

—1.建表

create table t_score(
sno number,
scalss number,
chinese number,
english number,
arith number
);

—2.插入数据

insert into t_score values(1,1,83,57,73);
insert into t_score values(2,1,58,76,90);
insert into t_score values(3,3,89,84,96);
insert into t_score values(4,2,79,86,82);
insert into t_score values(5,1,58,81,93);
insert into t_score values(6,1,56,90,59);
insert into t_score values(7,3,77,66,77);
insert into t_score values(8,2,63,56,55);
insert into t_score values(9,1,91,78,91);
insert into t_score values(10,3,95,81,50);
commit;

—3.查询语句

select t.*,
       rank() over(partition by scalss order by chinese desc) as chinese_rank,
       rank() over(partition by scalss order by english desc) as english_rank,
       rank() over(partition by scalss order by arith desc) as arith_rank
  from t_score t
 order by scalss, arith_rank;