oracle中row_number()

ROW_NUMBER() OVER(PARTITION BY COLUMN1 ORDER BY COLUMN2)

结果：从表中选择，条件是按column1  分组   column2 排序    最后统计出每组的序号

形如：   学生分数                          年级                      序号

               99                                      一                           1

               88                                      一                           2

               85                                      一                           3

               67                                      一                           4

               95                                      二                           1

               90                                      二                           2

               85                                      二                           3