表temp存在如下数据
id | key |
1 | aaa |
2 | aaa |
3 | bbb |
4 | bbb |
5 | bbb |
6 | ccc |
7 | ddd |
现在要查询出相同的key是第几次出现 select id,key, row_number()over(partition by key order by id) as num from temp
id | key | num |
1 | aaa | 1 |
2 | aaa | 2 |
3 | bbb | 1 |
4 | bbb | 2 |
5 | bbb | 3 |
6 | ccc | 1 |
7 | ddd | 1 |
表temp存在如下数据
id | key |
1 | aaa |
2 | aaa |
3 | bbb |
4 | bbb |
5 | bbb |
6 | ccc |
7 | ddd |
id | key | num |
1 | aaa | 1 |
2 | aaa | 2 |
3 | bbb | 1 |
4 | bbb | 2 |
5 | bbb | 3 |
6 | ccc | 1 |
7 | ddd | 1 |