请在 下方输入 要搜索的题目:

下面语句中能够查询出部门编号是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
推荐参考答案 ( 由 快搜搜题库 官方老师解答 )
联系客服
答案:select * from department where dep_num in (1001,1002,1003); ■select * from department where dep_num=1001 or dep_num=1002 or dep_num=1003; ■select * from department where dep_num between 1001 and 1003;
专业技术学习
专业技术学习
搜搜题库系统