本文探讨了如何使用SQL查询从数据库中筛选特定文件名、AC_HHOLD和TRIPS，进而通过数据透视表实现复杂的数据聚合分析。
SELECT AC_HHOLD, [2012042],[2012043],[2012044],[2012045],[2012046],[2012047],[2012048] FROM (
select FILENAME, AC_HHOLD, COUNT(*) AS TRIPS
from PURCHASE
where AC_barcode='B'
GROUP BY FILENAME, AC_HHOLD
) as a
PIVOT
(MAX(TRIPS) FOR FILENAME IN ([2012042],[2012043],[2012044],[2012045],[2012046],[2012047],[2012048])) as T
select FILENAME, AC_HHOLD, COUNT(*) AS TRIPS
from PURCHASE
where AC_barcode='B'
GROUP BY FILENAME, AC_HHOLD
) as a
PIVOT
(MAX(TRIPS) FOR FILENAME IN ([2012042],[2012043],[2012044],[2012045],[2012046],[2012047],[2012048])) as T
扫一扫
3103
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
