举一反三
- 有学生信息表student,求年龄在20-22岁之间(含20岁和22岁)的学生姓名和年龄的SQL语句是: SELECT sname,age FORM student WHERE age 【18】
- 有学生信息表student,求年龄在20~22岁之间(含20岁和22岁)的学生姓名和年龄的SQL语句是:SELECT sname,age FROM student WHERE age( )。 A: >20 and age<22 B: BETWEEN 20 AND 22 C: >=20 and age<22 D: >20 and age<=22
- 对于学生信息表:student(sno,sname,sex,age,dept),能够得到年龄在20岁至22岁之间的学生的姓名和学号的语句是( )。 A: SELECT*FROM student WHERE age BETWEEN 20 AND 22 B: SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22 C: SELECT sname,sno FROM student WHERE age>=20 D: SELECT sname,sno FROM student WHERE age<=22
- 中国大学MOOC: 有学生信息表student,求年龄在20~22岁之间(含20岁和22岁)的学生姓名和年龄的SQL语句是:SELECT sname,age FROM student WHERE age( )。
- 有学生信息表student,求年龄在20岁到22岁之间(含20岁和22岁)的学生姓名和年龄的 SQL语句是: SELECT sname, age FROM student WHERE age ______;
内容
- 0
关系模式:Student(Sno, Sname, Age),其中Sno、Sname、Age分别表示学生的学号、姓名和年龄。“查询年龄大于20岁的学生姓名”的关系代数表达式是() A: σSname(σage>20(Student)) B: ΠSname(σage>20(Student)) C: σSname(Πage>20(Student)) D: ΠSno(σage>20(Student))
- 1
查询年龄不在20到23岁之间的学生的信息,所使用的语法命令为() A: select * from student where age not between 20 and 23 B: select * from student where age between 20 and 23 C: select * from student where age not between 20 to 23 D: select * from student where not age from 20 to 23
- 2
查询年龄在20到23岁之间的学生的信息,所使用的语法命令为() A: select * from student where age between 20 to 23 B: select * from student where age from 20 to 23 C: select * from student where age between 20 and 23 D: select * from student
- 3
数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求写SQL语句查询出表中年龄介于20和30岁之间的数据,下列哪个SQL语句是正确的?() A: Select* From Student Where Age>=20 ANDAge>=30 B: Select* From Student Where Age>=20 ANDAge<=30 C: Select* From Student Where Age BET WENN 20AND30 D: Select* From Student Where Age>=20&&Age>=30"
- 4
已知学生表student(sid,sname,sex,age0,其各个属性分别表示学号、姓名、性别和年龄,若要从表中检索所有学生的信息,检索结果按年龄由大到小排序,下列SQL语句正确的是( ) A: select * from student order by age B: select * from student group by age C: select * from student order by age desc D: select * from student group by age desc