SQL如何编写查询同时满足多行条件的语句（有图）

2025-04-06 03:31:34

推荐回答（3个）

回答1：

select cno,bno from borrow
where bno = 1
or bno = 2

如果还有其他条件的话，需要将or的条件括起来，这样才不会出错如
select cno,bno from borrow
where (bno = 1
or bno = 2)
and cno <> '1004'

或者
select cno,bno from borrow
where bno in('1','2')

回答2：

select cno,bno
from borrow
where bno in(1,2)

回答3：

Select * from borrow where cno in

(

Select cno from

(select distinct cno,bno from borrow where bno in ('1','2') ) as a group by cno having count(cno)>1
) as b