Jason_05的博客

首先建一个表create table chengji(id NUMBER,name VARCHAR2(20),course VARCHAR2(20),score NUMBER); insert into chengji (id, name, course, score)values (1, '张三', '语文', 67);insert into chengji (id, ...

一、ROW_NUMBER()的用法语法：ROW_NUMBER() OVER(PARTITION BY COLUMN ORDER BY COLUMN)row_number()从1开始，为每一条分组记录返回一个数字，这里的ROW_NUMBER() OVER (ORDER BYcolum DESC) 是先把colum列降序，再为降序以后的每条colum记录返回一个序号。ROW_NUMBE...