By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
RID | ID | DENSE_RANK()OVER(ORDERBYT2.MAX_RID) |
---|---|---|
8100 | 161 | 1 |
8101 | 2 | 2 |
8102 | 2 | 2 |
8103 | 2 | 2 |
8104 | 156 | 3 |