asp,查询一个字段,并且同时满足多个条件where怎么写啊?

2025-03-24 22:26:22
推荐回答(4个)
回答1:

如果AA是数字类型
Select * from mama where AA in (2,4,6)
如果AA是字符类型
Select * from mama where AA in ('2','4','6')

回答2:

1、SELECT * FROM [mama]] WHERE AA in(2,4,6);
2、SELECT * FROM [mama]] WHERE AA=2 and AA=4 and AA=6;

回答3:

可以用where aa in (2,4,6)

回答4:

select * from mama where aa=2 or aa=4 or aa=6