我在查询中具有以下case语句的group by子句,但我也想通过group将另一列添加到group:
group by case @dateType
WHEN 'Daily' then i.overridedate
WHEN 'Weekly' then dateadd(day,-1*datepart(weekday,i.overridedate)+1,i.overridedate)
WHEN 'Monthly' THEN DATEADD(day, -1*DATEpart(day,i.overridedate)+1, i.overridedate)
WHEN 'Quarterly' THEN dateadd(mm,-3,DATEADD(qq, DATEDIFF(qq,0,i.overridedate )+1, 0)) END
如何在此群组中添加另一列?
group by case @dateType
WHEN 'Daily' then i.overridedate
WHEN 'Weekly' then dateadd(day,-1*datepart(weekday,i.overridedate)+1,i.overridedate)
WHEN 'Monthly' THEN DATEADD(day, -1*DATEpart(day,i.overridedate)+1, i.overridedate)
WHEN 'Quarterly' THEN dateadd(mm,-3,DATEADD(qq, DATEDIFF(qq,0,i.overridedate )+1, 0)) END
--Edited
,
col1,
col2,
etc..,
coln
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句