下面语句中能够查询出部门编号是1001、1002、1003的部门员工信息的是 。( )
A、select * from department where dep_num in (1001,1002,1003);
B、select * from department where dep_num=1001 or dep_num=1002 or dep_num=1003;
C、select * from department where dep_num=1001 and dep_num=1002 and dep_num=1003;
D、select * from department where dep_num between 1001 and 1003;
发布时间:2025-07-11 23:32:27