问题:
ID Rownum - 1
1 0
1 1
1 2
1 3
2 4
2 5
2 6
3 7
变成
ID Rownum - 1
1 0
1 1
1 2
1 3
2 0
2 1
2 2
3 0
相当于根据id去分组,在对同id的进行排序.
解:
select id, row_number() over (partition by id order by id) from table
partition by 为oralce的分组函数,
ID Rownum - 1
1 0
1 1
1 2
1 3
2 4
2 5
2 6
3 7
变成
ID Rownum - 1
1 0
1 1
1 2
1 3
2 0
2 1
2 2
3 0
相当于根据id去分组,在对同id的进行排序.
解:
select id, row_number() over (partition by id order by id) from table
partition by 为oralce的分组函数,