在学生表STUD中,查询年龄在20至23岁之间的学生的姓名(XM)、年龄(SA)和所在系(SD),实现该功能的正确SQL语句是( )。
A: SELECT XM,SA,SD FROM STUD WHERE BETWEEN 20B.SELECT XM,SA,SD.FROM STUD WHERE SA BETWEEN 23 AND 20
B: SELECT XM,SA,SD FROM STUD WHERE SA NOT BETWEEN 20 AND 23
C: SELECT XM,SA,SD FROM STUD WHERE SA BETWEEN 20 AND 23
A: SELECT XM,SA,SD FROM STUD WHERE BETWEEN 20B.SELECT XM,SA,SD.FROM STUD WHERE SA BETWEEN 23 AND 20
B: SELECT XM,SA,SD FROM STUD WHERE SA NOT BETWEEN 20 AND 23
C: SELECT XM,SA,SD FROM STUD WHERE SA BETWEEN 20 AND 23
举一反三
- 在学生表STUD中,查询年龄在20~23岁之间的学生的姓名(XM)、年龄(SA)和所在系(SD),实现该功能的正确SQL语句是______。 A: SELECT XM, SA, SD FROM STUD WHERE BETWEEN 20<SA<23; B: SELECT XM, SA, SD FROM STUD WHERE SA BETWEEN 23 AND 20; C: SELECT XM, SA, SD FROM STUD WHERE SA NOT BETWEEN 20 AND 23; D: SELECT XM, SA, SD FROM STUD WHERE SA BETWEEN 20 AND 23;
- 在学生表STUD中,查找年龄在20~23岁之间的学生姓名(XM)、年龄(SA)和所在系(SD),实现该功能的正确SQL语句是______。 A: SELECT XM,SA,SD FROM STUD B: WHERE BETWEEN 20<SA<23; C: SELECT XM,SA,SD FROM STUD D: WHERE SA BETWEEN 23 AND 20; E: SELECT XM,SA,SD FROM STUD F: WHERE SA NOT BETWEEN 20 AND 23; G: SELECT XM,SA,SD FROM STUD H: WHERE SA BETWEEN 20 AND 23
- 在学生表STUD中,查询年龄在20~23岁之间的学生的姓名(XM)、年龄(S A: 和所在系(SD),实现该功能的正确SQL语句是______。A) SELECT XM, SA, SD FROM STUD B: WHERE BETWEEN 20<SA<23; C: SELECT XM, SA, SD FROM STUD D: WHERE SA BETWEEN 23 AND 20; E: SELECT XM, SA, SD FROM STUD F: WHERE SA NOT BETWEEN 20 AND 23; G: SELECT XM, SA, SD FROM STUD H: WHERE SA BETWEEN 20 AND 23;
- 在学生表STUD中,查询年龄在20至23岁之间的学生的姓名(XM)、年龄(S A: 和所在系(SD) ,实现该功能的正确SQL语句是______。A) SELECTXM,SA,SD FROM STUD B: WHERE BETWEEN 20B.SELECT XM,SA,SD FROM STUD C: WHERE SA BETWEEN 23 AND 20; D: SELECT XM,SA,SD FROM STUD E: WHERE SA NOT BETWEEN 20 AND 23; F: SELECT XM,SA,SD FROM STUD G: WHERE SA BETWEEN 20 AND 23;
- 在学生表STUD中,查询年龄在20至23岁之间的学生的姓名(XM),年龄(SA)和所在系(SD),实现该功能的正确SQL语句是( )。 A: SELECT XM, SA, SD FROM STUD B: WHERE BETWEEN 20<SA<23 C: SELECTXM, SA, SD FROM STUD D: WHERE SA BETWEEN 23 AND 20 E: SELECTXM, SA, SD FROM STUD F: WHERE SA NOTBETWEEN20 AND 23 G: SELECTXM, SA, SD FROM STUD H: WHERE SA BETWEEN 20 AND 23