Question

我的表象

Here I need to return true when my condition is something like .. where fid=53 and id in(20,23,53) and also I need to return false when....where fid=53 and id in(20,24,53). But the above condition not satisfy my requirement.Both queries returns same value(true).Please help me to go forward.

Answer 1

我认为,你再次要求的是,要找到与20,23,53 和如果不是的话,那是 que的 t。

这在结构中有两个共同的解决办法。

首先,我建议我为我的SQL:

SELECT t1.fid
FROM mytable t1
JOIN mytable t2 ON t1.fid = t2.fid
JOIN mytable t3 ON t1.fid = t2.fid
WHERE (t1.id, t2.id, t3.id) = (20,23,53);

这里还有另一种解决办法,即使用群体而不是自谋职业,但在我的SQL中往往更糟:

SELECT t.fid
FROM mytable t
WHERE t.id IN (20,23,53)
GROUP BY t.fid
HAVING COUNT(*) = 3;

Answer 2

也许会是一个分局?

SELECT id, fid FROM table
WHERE fid = 53 AND
id IN ( SELECT id FROM table WHERE id IN(20,24,53))

Answer 3

According to your example conditions, its not possible with a single query :(. since where fid=53 and id in(20,23,53) return true for fid=53 and id =20,53 Similarly, where fid=53 and id in(20,24,53) is false for fid=53 and id =20,53

唯一的区别是id=23和id=24。因此,你可以提出两个不同问题。但有时他们会以同样数据换取真实和虚假的回报。

我认为,你需要再次思考你的问题。

友情链接