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

有学生信息表student,求年龄在20~22岁之间(含20岁和22岁)的学生姓名和年龄的SQL语句是: SELECT sname, age FORM student WHERE age 【1...

查看本题答案

你可能感兴趣的试题

SELECT * FROM student WHERE age BETWEEN 20 AND 22  SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22  SELECT sname,sno FROM student WHERE age>=20  SELECT sname,sno FROM student WHERE age<=22  
SELECT * FROM student WHERE age BETWEEN 20 AND 22  SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22  SELECT sname,sno FROM student WHERE age>=20  SELECT sname,sno FROM student WHERE age<=22  
SELECT*FROM student WHERE age BETWEEN 20 AND 22  SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22  SELECT sname,sno FROM student WHERE age>=20  SELECT sname,sno FROM student WHERE age<=22  
SELECT SNAME,AGE FROM STUDENT  WHERE AGE>20 AND AGE<23  SELECT*FROM STUDENT  WHERE AGE BETWEEN 20 AND 23  SELECTSNAME,AGE FROM STUDENT  WHERE AGE BETWEEN 20 AND 23  以上均不正确  
SELECF FROM student WHERE age BETWEEN 20 AND 22  SELECT sname, sno FROM student WHERE age BETWEEN 20 AND 22  SELECT sname, sno FROM student WHERE age>=20  SELECT sname, sno FROM student WHERE age<=22  
SELECT*FROM student WHERE age BETWEEN 20 AND 22  SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22  SELECT sname,sno FROM student WHERE age>=20  SELECT sname,sno FROM student WHERE age<=22  
SELECT * FROM student WHERE age BETWEEN 20 AND 22  SELECT sname, sno FROM student WHERE age BETWEEN 20 AND 22  SELECT sname,sno FROM student WHERE age>=20  SELECT shame,sno FROM student WHERE age<=22  
SELECT SNAME,AGE FROM S WHERE AGE>20 AND AGE<23  SELECT SNAME,AGE FROM S WHERE AGE BETWEEN 20 AND 23  SELECT *FROM S WHER AGE BETWEEN 20 AND 23  以上均不正确  
SELECT * FROM student WHERE age BETWEEN 20 AND 22  SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22  SELECT sname,sno FROM student WHERE age>=20  SELECT sname,sno FROM student WHERE age<=22  
SELECT SNAME, AGE FRQM S WHERE AGE>20 OR AGE<23  SELECT SNAME, AGE FROM S WHERE AGE BETWEEN 20 AND 23  SELECT FROM S WHERE AGE BETWEEN 20 AND 23  以上均不正确  

热门试题

更多