Question

SQL语句如何用一条语句查找两个ID的数据

我这样写的 select StudentName from Student where StudentId='111'and'222'
我知道是错的, 应该用什么语句?

Answer 1

select StudentName from Student where StudentId in('111','222');
--用in.

Answer 2

两个id都查应该用或的条件:
select StudentName from Student where StudentId='111' or id='222'

Answer 3

把and改为or就行了
select StudentName from Student where StudentId='111’or '222'

Answer 4

吧and改为or 并且用空格分开