如果我有一个类似下面这样的MySQL表：
company_name action pagecount ------------------------------- Company A PRINT 3 Company A PRINT 2 Company A PRINT 3 Company B EMAIL Company B PRINT 2 Company B PRINT 2 Company B PRINT 1 Company A PRINT 3
是否可能运行一个MySQL查询来获得以下输出：
company_name EMAIL PRINT 1页 PRINT 2页 PRINT 3页 ------------------------------------------------------------- CompanyA 0 0 1 3 CompanyB 1 1 2 0
想法是pagecount可以变化，所以输出的列数应该反映出来，每个action/pagecount对应一个列，然后是每个company_name的点击次数。我不确定这是否被称为数据透视表，但有人建议这样做？
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
2
1120
收藏
我的解决方案是使用T-SQL而没有任何透视：
SELECT CompanyName, SUM(CASE WHEN (action='EMAIL') THEN 1 ELSE 0 END) AS Email, SUM(CASE WHEN (action='PRINT' AND pagecount=1) THEN 1 ELSE 0 END) AS Print1Pages, SUM(CASE WHEN (action='PRINT' AND pagecount=2) THEN 1 ELSE 0 END) AS Print2Pages, SUM(CASE WHEN (action='PRINT' AND pagecount=3) THEN 1 ELSE 0 END) AS Print3Pages FROM Company GROUP BY CompanyName