表A
boxID bookID
269 187
269 188
270 187
271 187
272 188
我查询bookID为187和188 boxID相同时的boxID字段值
我的SQL
select d.s_ais_inforbox_id
from s_ais_inforbookd d
where d.s_ais_inforbox_id is not null
and (d.s_ais_inforbook_id=187 or d.s_ais_inforbook_id=188)
group by d.s_ais_inforbox_id
having count(d.s_ais_inforbox_id)=2
我不敢肯定自己在其他情况下是否正确大家帮忙看下我的SQL谢谢
boxID bookID
269 187
269 188
270 187
271 187
272 188
我查询bookID为187和188 boxID相同时的boxID字段值
我的SQL
select d.s_ais_inforbox_id
from s_ais_inforbookd d
where d.s_ais_inforbox_id is not null
and (d.s_ais_inforbook_id=187 or d.s_ais_inforbook_id=188)
group by d.s_ais_inforbox_id
having count(d.s_ais_inforbox_id)=2
我不敢肯定自己在其他情况下是否正确大家帮忙看下我的SQL谢谢
from s_ais_inforbookd d
where d.s_ais_inforbox_id is not null
and (d.s_ais_inforbook_id=187 or d.s_ais_inforbook_id=188)
group by d.s_ais_inforbox_id
having count(*)>=2
having count(d.s_ais_inforbox_id)=2改为
having count(d.s_ais_inforbox_id)>=2