单选题
在SQL Server中,查询出员工表(Employee)中户籍所在地(address)在上海,北京,陕西的员工信息,以下语句正确的是( )
A
select * from Employee where address or('上海','北京','陕西')
B
select * from Employee where address in('上海','北京','陕西')
C
select * from Employee where address in(上海,北京,陕西)
D
select * from Employee where address or(上海,北京,陕西)
答案解析
正确答案:B
解析:
概念理解
