首页 > 解决方案 > 将带计数的 MS Access 转换查询转换为 SQL Server PIVOT

问题描述

TRANSFORM Count(dbo_t_MARKETO_Comined_Analytics.[Email Address]) AS [CountOfEmail Address] SELECT dbo_t_MARKETO_Comined_Analytics.[Email Address] FROM dbo_t_MARKETO_Comined_Analytics GROUP BY dbo_t_MARKETO_Comined_Analytics.[Email Address] PIVOT dbo_t_MARKETO_Comined_Analytics.;

标签: ms-access

解决方案


推荐阅读