Customers to buy a commodity, b goods, goods c
Now want to query the customer what goods to buy how many times, want to query directly out of a two-dimensional table, the column name:
Customer's name, a number of commodity purchase, b goods purchase number

thank you

CodePudding user response:

Ok, the pivot/unpivot turn under the column to understand