sql - Oracle SQL中奇怪的缺少右括号错误

Question

我有这个where子句，当我尝试保存它时，会显示“缺少右括号”错误。代码如下：

where
(
  (a.date is not null 
  and sysdate between b.date and b.date2
  and b.per_id is not null
  group by b.per_id)

or 
  (a.date is null
  and b.per_id is not null
  group by b.per_id)
)

这样做的目的是检查何时a.date仅null输出满足的值，sysdate between b.date and b.date2否则何时a.date仅not null输出满足的值sysdate not between b.date and b.date2

标签： sqloracle

Answer 1

group by是该子句之后的where子句。这不是一个条件。

所以你要：

select . . .
from . . .
where (a.date is not null and
       sysdate between b.date and b.date2 and
       b.per_id is not null
      ) or 
      (a.date is null and
       b.per_id is not null 
      )
group by b.per_id