sql - 或 postgres 中的条件

Question

我想获取事件 ID 为 event_id ='NGO102' 或 event_id ='NGO103' 或 event_id ='NGO109' 或 event_id ='NGO111' 的数据

这是我的问题

select  event_id, orgname,event_date,num_of_event_pa,start_date
FROM event_details a  
INNER JOIN registration b on a.orgname =b.org_name  
where event_date >= '2017-03-31 00:00:00' AND event_date <= '2018-04-01 00:00:00' or event_id ='NGO102' or event_id ='NGO103' or event_id ='NGO109' or event_id ='NGO111'
 group by a.event_id, a.orgname,a.published_date, b.num_of_event_pa, b.start_date
     order by event_id DESC

但它显示我需要的所有记录，其中有 event_id 是event_id ='NGO102' 或 event_id ='NGO103' 或 event_id ='NGO109' 或 event_id ='NGO111'。我在哪里做错了请指导我谢谢

Answer 1

您可能希望在括号内的每个 OR 上使用 AND 条件。

..
 AND event_date <= '2018-04-01 00:00:00' AND 
(  event_id = 'NGO102' OR event_id = 'NGO103' OR event_id = 'NGO109'
OR event_id = 'NGO111'
)..

您可以使用 IN

简化它

..  AND event_date <= '2018-04-01 00:00:00' 
    AND event_id IN ( 'NGO102','NGO103','NGO109','NGO111') ..