下面语句中能够查询出部门编号是1001、1002、1003的部门员工信息的是（)。

A.select * from department where dep_numin(1001,1002,1003);

B.select * from department where dep_num=1001 and dep_num=1002 and dep_num=1003;

C.select * from department where dep_num=1001 or dep_num=1002 or dep_num=1003;

D.select * from department where dep_num between 1001 and 1003;