Case when ……… then………else ……end

最新推荐文章于 2022-04-30 21:12:45 发布

原创最新推荐文章于 2022-04-30 21:12:45 发布 · 1.7k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#email #sql

C#基础同时被 2 个专栏收录

8 篇文章

订阅专栏

SQL Server

4 篇文章

订阅专栏

本文提供SQL查询案例，包括使用CASE语句进行复杂条件判断及聚合运算，如按月统计促销活动参与情况等。

sql范例:

select Email,count(Guid)as TotalOrderCount,sum(case when PromotionType=8 then 1 else 0 end)as OriginalCount, sum( SaleTotalPrice )as SumTotalPrice,sum(case when PromotionType=8 then SaleTotalPrice else 0 end)as SumOriginalPrice into #t from #torder group by Email order by Email

CASE的多条件应用

select email,(CASE WHEN createmonth=1 THEN case when promotion=1 then 1 else 0 end ELSE 0 END) as ontad, (case when createmonth=1 then case when promotion=1 then 1 else 0 end else 0 end )as onefeiad, (case when createmonth=2 then case when promotion=1 then 1 else 0 end else 0 end )as twoad, (case when createmonth=2 then case when promotion=1 then 1 else 0 end else 0 end )as twofeiad from #o_one select email,sum(CASE WHEN createmonth=1 and promotion=1 then 1 ELSE 0 END) as ontad sum(case when createmonth=1 and promotion=1 then 1 else 0 end )as onefeiad, sum(case when createmonth=2 and promotion=1 then 1 else 0 end )as twoad, sum(case when createmonth=2 and promotion=1 then 1 else 0 end )as twofeiad from #o_one