oracle rank 语法_Oracle 的开窗函数 rank,dense_rank,row_number

1、开窗函数和分组函数的区别

分组函数是指按照某列或者某些列分组后进行某种计算，比如计数，求和等聚合函数进行计算。

开窗函数是指基于某列或某些列让数据有序，数据行数和原始数据数相同，依然能曾现个体数据的原貌。

事例数据

create table student_scores(

stu_id varchar2(10),--学号

stu_name varchar2(20),--姓名

course varchar2(5),--课程

score number(5,2),--分数

constraint pk_stuid_course primary key (stu_id,course)

);

insert into student_scores(stu_id,stu_name,course,score) values('10001','周杰伦','语文','85');

insert into student_scores(stu_id,stu_name,course,score) values('10001','周杰伦','数学','96');

insert into student_scores(stu_id,stu_name,course,score) values('10001','周杰伦','英语','67');

insert into student_scores(stu_id,stu_name,course,score) values('10002','谢霆锋','语文','71');

insert into student_scores(stu_id,stu_name,course,score) values('10002','谢霆锋','数学','97');

insert into student_scores(stu_id,stu_name,course,score) values('10002','谢霆锋','英语','100');

insert into student_scores(stu_id,stu_name,course,score) values('10003','苏有朋','语文','79');

insert into student_scores(stu_id,stu_name,course,score) values('1000