当前位置: X题卡 > 所有题目 > 题目详情

在学生表STUD中,查找年龄在20~23岁之间的学生姓名(XM)、年龄(SA)和所在系(SD),实现该功能的正确SQL语句是______。

查看本题答案

你可能感兴趣的试题

SELECT XM,SA,SD FROM STUD   WHERE BETWEEN 20<SA<23;  SELECT XM,SA,SD FROM STUD   WHERE SA BETWEEN 23 AND 20  SELECT XM,SA,SDFROM STUD   WHERE SA NOT BETWEEN 20 AND 23  SELECT XM,SA,SDFROM STUD   WHERE SA BETWEEN 20 AND 23  
SELECT XM,SA,SD FROM STUD WHERE BETWEEN 20<SA<23;  SELECTXM,SA,SD FROM STUD WHERE SA:BETWEEN 23 AND 20;  SELECTXM,SA,SD FROM STUD WHERE SA NOTBETWEEN20 AND 23;  SELECTXM,SA,SD FROM STUD WHERE SA BETWEEN 20 AND 23;  
和所在系(SD) ,实现该功能的正确SQL语句是______。A) SELECTXM,SA,SD FROM STUD
WHERE BETWEEN 20SELECTXM,SA,SD FROM STUD
WHERE SA BETWEEN23AND20;  
SELECTXM,SA,SD FROM STUD
WHERE SA NOTBETWEEN20 AND 23;  
SELECTXM,SA,SD FROM STUD
WHERE SA BETWEEN 20 AND 23;  
SELECT XM,SA,SD FROM STUD WHERE BETWEEN 20SELECT XM,SA,SFROM STUD WHERE SA BETWEEN 23 AND 20  SELECT XM,SA,SD FROM STUD WHERE SA NOT BETWEEN 20 AND 23  SELECT XM,SA,SD FROM STUD WHERE SA BETWEEN 20 AND 23  
SELECT XM,SA,SD FROM STUD WHERE BETWEEN 20<SA<23  SELECT XM,SA,SD FROM STUD WHERE SA BETWEEN 23 AND 20  SELECT XM,SA,SD FROM STUD WHERE SA NOT BETWEEN 20 AND 23  SELECT XM,SA,SDFROM STUD WHERE SA BETWEEN 20 AND 23  
和所在系(SD) ,实现该功能的正确SQL语句是______。A) SELECTXM,SA,SD FROM STUD
WHERE BETWEEN 20SELECT XM,SA,SD FROM STUD
WHERE SA BETWEEN 23 AND 20;  
SELECT XM,SA,SD FROM STUD
WHERE SA NOT BETWEEN 20 AND 23;  
SELECT XM,SA,SD FROM STUD
WHERE SA BETWEEN 20 AND 23;  
SELECTXM, SA, SD FROM STUD WHERE BETWEEN 20<SA<23  SELECTXM, SA, SD FROM STUD WHERE SA BETWEEN 23 AND 20  SELECTXM, SA, SD FROM STUD WHERE SA NOTBETWEEN20 AND 23  SELECTXM, SA, SD FROM STUD WHERE SA BETWEEN 20 AND 23  
SELECTXM, SA, SD FROM STUD
WHERE BETWEEN 20<SA<23  
SELECTXM, SA, SD FROM STUD
WHERE SA BETWEEN 23 AND 20  
SELECTXM, SA, SD FROM STUD
WHERE SA NOTBETWEEN20 AND 23  
SELECTXM, SA, SD FROM STUD
WHERE SA BETWEEN 20 AND 23  
SELECT*FROM STUD WHERE 姓名 LIKE"张%”  SELECT*FROM STUD WHERE 姓名 IN("张%")  SELECT*FROM STUD WHERE 姓名 LIKE"张$"  SELECT*FROM STUD WHERE 姓名 IN"张$)"  
SELECT XM, SA, SD FROM STUD
WHERE BETWEEN 20<SA<23  
SELECTXM, SA, SD FROM STUD
WHERE SA BETWEEN 23 AND 20  
SELECTXM, SA, SD FROM STUD
WHERE SA NOTBETWEEN20 AND 23  
SELECTXM, SA, SD FROM STUD
WHERE SA BETWEEN 20 AND 23  
和所在系(SD),实现该功能的正确SQL语句是A) SELECT XM,SA,SD FROM STUD
  WHERE BETWEEN 20<SA<23;  
SELECTXM,SA,SD FROM STUD
  WHERE SA BETWEEN23 AND 20  
SELECTXM,SA,SDFROM STUD
  WHERE SA NOT BETWEEN 20 AND23  
SELECT XM,SA,SDFROM STUD
  WHERE SA BETWEEN 20 AND23  
SELECT XM,SAFROM STUD FOR SA<20  SELECT XM,SA FROM STUD WHERE NOT SA>=20  SELECT XM,SA ON STUD FOR SA<20  SELECT XM,SA ON STUD WHERE SA<20  
SELECT XM,SA FROM STUD FOR SA<20  SELECT XM,SA FROM STUD WHERE NOT SA>=20  SELECT XM,SA ON STUD FOR SA<20  SELECT XM,SA ON STUD WHERE SA<20  
和所在系(SD) 。实现该功能的正确SQL语句是 ______。A) SELECT XM,SA,SD FROM STUD WHERE BETWEEN 20<SA<23  SELECT XM,SA,SD FROM STUD WHERE SA BETWEEN 23 AND 20  SELECT XM,SA,SD FROM STUD WHERE SA NOT BETWEEN 20 AND 23  SELECT XM,SA,SDFROM STUD WHERE SA BETWEEN 20 AND 23  
和所在系(SD),实现该功能的正确SQL语句是______。A) SELECT XM, SA, SD FROM STUD
WHERE BETWEEN 20<SA<23;  
SELECT XM, SA, SD FROM STUD
WHERE SA BETWEEN 23 AND 20;  
SELECT XM, SA, SD FROM STUD
WHERE SA NOT BETWEEN 20 AND 23;  
SELECT XM, SA, SD FROM STUD
WHERE SA BETWEEN 20 AND 23;  
SELECT * FROM STUD WHERE 姓名LIKE“张%”  SELECT * FROM STUD WHERE 姓名IN(“张%”)  SELECT * FROM STUD WHERE 姓名LIKE“张$”  SELECT * FROM STUD WHERE 姓名IN(“张$)”  
SELECT XM,SA,SD FROM STUD   WHERE BETWEEN 20<SA<23;  SELECTXM,SA,SD FROM STUD   WHERE SA BETWEEN23 AND 20  SELECTXM,SA,SDFROM STUD   WHERE SA NOT BETWEEN 20 AND23  SELECT XM,SA,SDFROM STUD   WHERE SA BETWEEN 20 AND23  
SELECT XM, SA, SD FROM STUD WHERE BETWEEN 20<SA<23;  SELECT XM, SA, SD FROM STUD WHERE SA BETWEEN 23 AND 20;  SELECT XM, SA, SD FROM STUD WHERE SA NOT BETWEEN 20 AND 23;  SELECT XM, SA, SD FROM STUD WHERE SA BETWEEN 20 AND 23;  
和所在系(SD) ,实现该功能的正确SQL语句是( )。A) SELECT XM,SA,SD FROM STUD
WHERE BETWEEN 20<SA<23;  
SELECTXM,SA,SD FROM STUD
WHERE SA:BETWEEN 23 AND 20;  
SELECTXM,SA,SD FROM STUD
WHERE SA NOTBETWEEN20 AND 23;  
SELECTXM,SA,SD FROM STUD
WHERE SA BETWEEN 20 AND 23;  
。实现该功能的正确SQL语句是______。A) SELECT XM,SA FROM STUD FOR SA<20  SELECT XM,SA FROM STUD WHERE NOT SA>=20  SELECT XM,SA ON STUD FOR SA<20  SELECT XM,SA ON STUD WHERE SA<20  

热门试题

更多