I have a table that I would like to group by row. With “group by” the entire column is always grouped.
Source-Table
| ID | HBS1 |
|---|---|
| 1 | MU |
| 1 | S |
| 1 | S |
| 1 | S |
| 1 | T |
| 1 | T |
| 1 | SZ |
| 1 | S |
| 1 | S |
| 1 | S |
Wish-Table
| ID | HBS1 | COUNT |
|---|---|---|
| 1 | MU | 1 |
| 1 | S | 3 |
| 1 | T | 2 |
| 1 | SZ | 1 |
| 1 | S | 3 |
I hope you can help me a little. Thanks.
New contributor
Maik Gellendin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.