我想选择包含选定ID但不只包含来自同一列表的这些ID的记录。
我的SQL代码：
select question_id, person_id from `answers` where
`person_id` in ('9', '18')
结果：
2, 9
2, 18
4, 9
4, 18
5, 18
6, 9
预期成绩：
5, 18
6, 9
完整的SQL查询：
select id, name
from questions
where id not in ('3', '13') and
exists (select `id` from `answers` where `answers`.`question_id` = `questions`.`id`
and `person_id` in ('9', '18')) order by RAND() limit 1
您可以尝试使用分组方式
select question_id, person_id
from `answers`
where person_id` in ('9', '18')
group by question_id
having count(distinct person_id) = 1
只选择集合中具有person_id但仅匹配一个值的行
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句