sql - 如何按日期过滤排除数据

Question

我需要实现以下逻辑

排除患者日期为事件日期或事件日期前 1 天的患者:

select patient,[patient date], [event date] 
from stu_tbl 
where [patient date] <> DATEADD(d, - 1, [event date]) and 
      [patient date] <> [event date];

患者日期将是多个

上述条件是否可行？

Answer 1

听起来更像你想要的

select patient,
           [patient date],
           [event date]
           from stu_tbl
           where [patient date] >= DATEADD(d, - 1, [event date])
                      and [patient date] < cast([event date] AS date);