declare @sqlText nvarchar(2000)

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

gz775

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

阅读量893

点赞数

CC 4.0 BY-SA版权

文章标签： null

本文链接：https://blog.youkuaiyun.com/gz775/article/details/5150435

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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