在Access中已经建立了学生表,若查询学号是"S0001"和"S0002"的记录。查询设计器的条件行应该输入( )。
A: "S0001" OR "S0002"
B: "S0001" AND "S0002"
C: IN("S0001" AND "S0002")
D: IN("S0001" OR "S0002")
A: "S0001" OR "S0002"
B: "S0001" AND "S0002"
C: IN("S0001" AND "S0002")
D: IN("S0001" OR "S0002")
举一反三
- ipv6地址2000:0000:0000:0001:0002:0000:0000:0001采用零压缩法可以简写为()。
- 样宣的库存地点.( ) A: 0004 B: 0001 C: 0002 D: 0003
- IPv6地址2000:0000:0000:0001:0002:0000:0000:0001采用零压缩法可以简写为2000::1:2:0:0:1
- 根据程序,请判断输出结果:#include<stdio.h>struct stu{int num;char name[5];int age;char sex;};void fun(struct stu *p){printf("%s\n",(*p).name);}main(){struct stu stud[3]={{0001,"zhang",20,'f'},{0002,"li",18,'m'},{0003,"chen",19,'f'}};fun(stud+2);}
- 设学生表S、课程表C和学生选课表SC的结构如下; S(学号,姓名,年龄,系别) C(课程号,课程名) SC(学号,课程号,成绩) 查询学生姓名及所选修课程的课程号和成绩,实现此功能的SELECT语句是 ______。 A: SELECT 姓名,S课程号,S成绩FROM S WHERE学号=S学号 B: SELECT 姓名,S课程号,S成绩FROM SC WHERE学号=S成绩 C: SELECT 姓名,S课程号,S成绩FROM S,SC WHERE 学号=S学号 D: SELECT 姓名,S课程号,S成绩FROM S,SC