By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
| id | rnk | c1 | c2 | c3 | c4 | c5 |
|---|---|---|---|---|---|---|
| 1 | 1 | c1 | b1 | a1 | ||
| 2 | 1 | e2 | d2 | c2 | b2 | a2 |
| 2 | 2 | f2 | ||||
| 3 | 1 | e3 | d3 | c3 | b3 | a3 |
| 3 | 2 | j3 | i3 | h3 | g3 | f3 |
| 4 | 1 | a4 | ||||
| 5 | 1 | c5 | b5 | a5 |
7 rows affected
| id | rnk | c1 | c2 | c3 | c4 | c5 |
|---|---|---|---|---|---|---|
| 1 | 1 | c1 | b1 | a1 | ||
| 2 | 1 | e2 | d2 | c2 | b2 | a2 |
| 2 | 2 | f2 | ||||
| 3 | 1 | e3 | d3 | c3 | b3 | a3 |
| 3 | 2 | j3 | i3 | h3 | g3 | f3 |
| 4 | 1 | a4 | ||||
| 5 | 1 | c5 | b5 | a5 |