过滤掉SQL中的未来日期(WinSQL)

Question

我在winSQL中有一个这样的查询：

select CALENDAR as CALENDAR,
       HD_FLAG as HD_FLAG,
       counts as COUNTS,
       CAP_location as AREA,
where CALENDAR >= 20150101
group by 1,2,3,4

但是，我希望过滤掉未来的数据值。我可以添加一个函数或另一个where子句来过滤今天之后的日期吗？

Answer 1

使用WINSQL now()函数，这样：

 select CALENDAR as CALENDAR,
 HD_FLAG as HD_FLAG,
 counts as COUNTS,
 CAP_location as AREA,
 where CALENDAR >= now()
 group by 1,2,3,4