我可能有一个很简单的问题,我不能解决。我需要一个sql查询,它对一列中的两个值进行计数,并返回按产品分组的值。
我有一张这样的table
这是源表
如何在sql中进行生成下表的求值:
这是我的目标table
SELECT Product, Count(Role) as NumRole,
(SELECT Product, count(Role) as NumAdmin FROM tblprod WHERE Type='Admin') AS Admin,
(SELECT Product, count(Role) as NumAdmin FROM tblprod WHERE Type='User') AS User,
FROM tblprod
GROUP BY Product
1条答案
按热度按时间toe950271#
请尝试下面的查询。