我想通过以下查询
(statement1 AND statement2 AND (statement3 OR statement4 ))
这是我的配置单元查询,我验证了它不起作用,因为它仅返回statement3,而且我知道在某些情况下statement4为true
SELECT
cid,
SUM(count) AS total_count
FROM
count_by_day
WHERE
time >= 1435536000
AND time < 1436140800
AND(
cid = '4eb3441f282d4d657a000016'
OR cid = '14ebe153121a863462300043d'
)
GROUP BY
cid
有人可以告诉我怎么了吗?谢谢
还要检查以确保您的时间是数字类型,可能是bigint。如果没有将其转换为像这样的大整数:
WHERE cast(time as bigint) >= 1435536000 AND cast(time as bigint) < 1436140800
尝试将您的or语句更改为in语句。
SELECT
cid,
SUM(count) AS total_count
FROM
count_by_day
WHERE time >= 1435536000 AND time < 1436140800
AND cid in('4eb3441f282d4d657a000016','14ebe153121a863462300043d')
GROUP BY
cid;
一次尝试进行一次更改,以了解解决方法。
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句