匹配值的计数

Question

当immediate_id与start_id匹配或immediate_id与end_id.The匹配时，我想返回计数大于3的任何立即数。start_id将等于end_id且计数大于3，或者start_id将等于immediate_id且计数大于3。现在将返回该特定立即数的所有匹配，而不是该立即数的大于3的匹配。immediate有immediate_id，start有start_id，end有end_id，每个immediate有start，start_id有end和end_id。我只需要immediate_id = start_id > 3和immediate_id = end_id >3的情况。

select immediate
count(immediate) OVER (partition by start_id) as matchCount
from addresses where
start_id = end_id
or start_id = immediate_id
and year = 2016

Answer 1

您需要将or语句括在圆括号中，并实际将> 3添加到where子句中，如下所示：

where count(immediate) > 3 and (immediate_id = start_id or immediate_id = end_id)