declare @sqlText nvarchar(2000)

最新推荐文章于 2023-07-08 02:12:16 发布

原创最新推荐文章于 2023-07-08 02:12:16 发布 · 913 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#null

收录于

本文提供了一个SQL查询案例，展示了如何使用CASE语句进行条件求和，并通过GROUP BY进行分组统计。此外，还给出了一个动态构建SQL语句的例子，用于按月统计不同品牌的销售额。

declare @sqlText nvarchar(2000) select @sqlText='select month(nspdate) as mon,' select @sqlText=@sqltext+'sum(CASE brand WHEN '''+brand+''' THEN price ELSE 0 END) AS ''' +brand+ ''',' from (select distinct top 2 brand from main where brand<>'') as a select @sqlText=left(@sqlText,Len(@sqlText)-1)+' from main where nspdate between ''2009-01-01'' and ''2009-12-31'' group by month(nspdate) order by mon' print @sqltext exec(@sqlText)

SELECT month(publicationdate) as mon,
SUM(CASE region WHEN 'South China' THEN EAV ELSE NULL END) AS [South China],
SUM(CASE region WHEN 'North China' THEN EAV ELSE NULL END) AS [North China],
SUM(CASE region WHEN 'West China' THEN EAV ELSE NULL END) AS [West China]
FROM watsonspic GROUP BY month(publicationdate)
ORDER BY mon