语法
row_number() over( [partition by col1] order by col2[desc])
- row_number() 为返回的记录定义各行编号
- pritition by 分组
- order by 排序
实例
实例数据来源,利用pgAdmin数据库实践
建表
create table student(id serial,name character varying,course character varying,score integer);
插入数据
insert into student (name,course,score) values('周润发','语文',89);
insert into student (name,course,score) values('周润发','数学',