By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 10 Duplicates: 0 Warnings: 0
pkid | catid | value | rank |
---|---|---|---|
1 | p01 | 100 | 1 |
2 | p01 | 90 | 2 |
3 | p01 | 90 | 2 |
4 | p01 | 80 | 4 |
5 | p01 | 80 | 4 |
6 | p01 | 80 | 4 |
pkid | catid | value | dense_rank |
---|---|---|---|
1 | p01 | 100 | 1 |
2 | p01 | 90 | 2 |
3 | p01 | 90 | 2 |
4 | p01 | 80 | 3 |
5 | p01 | 80 | 3 |
6 | p01 | 80 | 3 |
7 | p01 | 70 | 4 |
8 | p01 | 60 | 5 |
pkid | catid | value | row_number |
---|---|---|---|
1 | p01 | 100 | 1 |
2 | p01 | 90 | 2 |
3 | p01 | 90 | 3 |
4 | p01 | 80 | 4 |
5 | p01 | 80 | 5 |