By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| category | Subcategory | cnt | rn |
|---|---|---|---|
| Bar | Blueberry | 2 | 1 |
| Foo | Apple | 3 | 1 |
8 rows affected
| category | Subcategory | cnt | rn |
|---|---|---|---|
| Bar | Blueberry | 2 | 1 |
| Foo | Apple | 3 | 1 |