与datediff之间的案例陈述

作者: 甲基蓝
发布时间: 2025-02-06 02:22:58 (1月前)
转自：

3 条回复

0#
回复此人
那月静好 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 每次使用when子句时都不需要case关键字。试试这个： </p> <pre> <code> SELECT a.cusid, start_date, effective_dt, case when DATEDIFF(DAY, start_date, effective_dt) >= 5476 THEN 'Green' when DATEDIFF(DAY, start_date, effective_dt) between 2921 AND 4575 THEN 'Red' when DATEDIFF(DAY, start_date, effective_dt) BETWEEN 1096 AND 2920 THEN 'Blue' when DATEDIFF(DAY, start_date, effective_dt) BETWEEN 0 AND 1095 THEN 'Rose' ELSE NULL END as tier FROM tablea a INNER JOIN tableb b ON a.cusid = b.cusid WHERE b.active = 'Yes' </code> </pre> </DIV>

编辑
1#
回复此人
夏花 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 你的语法略有偏差。你不需要 <code> case </code> 对于每个条件： </p> <pre> <code> SELECT a.cusid, start_date, effective_dt, CASE when DATEDIFF(DAY, start_date, effective_dt) >= 5476 THEN 'Green' when DATEDIFF(DAY, start_date, effective_dt) between 2921 AND 4575 THEN 'Red' when DATEDIFF(DAY, start_date, effective_dt) BETWEEN 1096 AND 2920 THEN 'Blue' when DATEDIFF(DAY, start_date, effective_dt) BETWEEN 0 AND 1095 THEN 'Rose' ELSE NULL END as tier FROM tablea a INNER JOIN tableb b ON a.cusid = b.cusid WHERE b.active = 'Yes' </code> </pre> </DIV>

编辑

登录后才能参与评论