已知user表中存在一个字段id。下面选项中，能够查询出id编号为u001和u002的用户的SQL语句是

题目：已知user表中存在一个字段id。下面选项中，能够查询出id编号为u001和u002的用户的SQL语句是

A. select * from user where id = 'u001' and id = 'u002';

B. select * from user where id = 'u001' or id = 'u002';

C. select * from user where id in ('u001','u002');

D. select * from user where id ('u001','u002');

答案：评论后可见此内容