By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
| Id | MyId | RandomNumber | rn1 |
|---|---|---|---|
| 1 | 1 | 1 | 0.899903072823665 |
| 1 | 2 | 1 | 0.899903072823665 |
| 1 | 3 | 1 | 0.899903072823665 |
| 1 | 4 | 1 | 0.899903072823665 |
| 2 | 1 | 4 | 0.0862327981961147 |
| 2 | 2 | 4 | 0.0862327981961147 |
| 2 | 3 | 4 | 0.0862327981961147 |
| 3 | 1 | 3 | 0.272562510778115 |