By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| gid | name | p1 | p10 | p100 | prev_p1 | prev_p10 | prev_p100 |
|---|---|---|---|---|---|---|---|
| 100 | Item1 | 149 | 1495 | 10247 | 149 | 1495 | 10245 |
| 857 | Item2 | 970 | 9879 | 89998 | 1099 | 9875 | 89999 |
| gid | name | p1 | p10 | p100 | prev_p1 | prev_p10 | prev_p100 |
|---|---|---|---|---|---|---|---|
| 100 | Item1 | 149 | 1495 | 10247 | 149 | 1495 | 10245 |
| 857 | Item2 | 970 | 9879 | 89998 | 1099 | 9875 | 89999 |