Row_number () over (partition by col1 order by col2)的用法 oracle row_number 函数 1 2 3 4 ROW_NUMBER() OVER (PARTITION BY COL1 ORDER BY COL2) --其中,COL1,COL2可以为多列 select xt.id, xt.item, xt.attribute1, xt.attribute2, ROW_NUMBER() OVER(PARTITION BY xt.id,xt.item order by xt.id,xt.item) test from xxuts_test xt 表示根