来自另一个Case表达式的case表达式
来自另一个Case表达式的case表达式
提问于 2020-12-07 18:28:04
我有SQL代码示例，它返回周数
,CASE WHEN dateadd(MONTH, datediff (MONTH,AgentStart, getdate()), AgentStart) > getdate()
THEN datediff(MONTH, AgentStart, getdate()) - 1
ELSE datediff(MONTH, AgentStart, getdate())
END as 'Month'我不去想现在如何添加一个新的列，它将给我提供这个结果(来自同一个表)：
,CASE WHEN **MONTH FROM CASE STATEMENT ABOVE** BETWEEN 0 AND 3 THEN 'Youngest'
WHEN **MONTH FROM CASE STATEMENT ABOVE** BETWEEN 4 AND 5 THEN 'Young'
WHEN **MONTH FROM CASE STATEMENT ABOVE** BETWEEN 6 AND 11 THEN 'Medium'
ELSE 'Old'
END AS "Status"回答 2
Stack Overflow用户
发布于 2020-12-07 18:32:23
您可以使用子查询：
SELECT `month`,
CASE WHEN `month` BETWEEN 0 AND 3 THEN 'Youngest'
WHEN `month` BETWEEN 4 AND 5 THEN 'Young'
WHEN `month` BETWEEN 6 AND 11 THEN 'Medium'
ELSE 'Old'
END AS Status
FROM (SELECT CASE
WHEN dateadd(MONTH, datediff (MONTH,AgentStart, getdate()), AgentStart) > getdate()
THEN datediff(MONTH, AgentStart, getdate()) - 1
ELSE datediff(MONTH, AgentStart, getdate())
END as `Month`
FROM mytable) tStack Overflow用户
发布于 2020-12-07 18:33:23
您可以编写一个内联视图来完成此任务
例如：
select case WHEN x.month_value BETWEEN 0 AND 3 THEN 'Youngest'
WHEN x.month_value BETWEEN 4 AND 5 THEN 'Young'
WHEN x.month_value BETWEEN 6 AND 11 THEN 'Medium'
ELSE 'Old'
END AS "Status"
,--rest of the columns from the inner query...
from (
select CASE
WHEN dateadd(MONTH, datediff (MONTH,AgentStart, getdate()), AgentStart) > getdate()
THEN datediff(MONTH, AgentStart, getdate()) - 1
ELSE datediff(MONTH, AgentStart, getdate())
END as month_value --naming it as month_value
from <table>
)x页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/65179991
复制相关文章
相似问题
腾讯云开发者
