PostgreSQL_row_number() over()

语法

row_number() over( [partition by col1] order by col2[desc]) 

1. row_number() 为返回的记录定义各行编号
2. pritition by 分组
3. 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('周润发','数学'