Name state project
Zhang SAN has read to-do
Zhang SAN has read to-do
Zhang SAN unread to-do
Li si has read to-do
Li si unread to-do
How can I get zhang SAN and li si has a record of how many respectively? thank you
CodePudding user response:
After the grouping count not fixCodePudding user response:
According to the name count after the groupingCodePudding user response:
If you think a DW group not good-looking, not beautiful, you can make a DW to take group by another. Retrieval condition, at the same time on the window, at the same time retrieval is finished