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"
举一反三
- 下面 语句和”select * from student where sex=’男’ && age=20;”语句查询出的结果是一样的。( ) A: select * from student where sex=’男’ or age=20; B: select * from student where sex=’男’ || age=20; C: select * from student where sex=’男’ and age=20; D: select * from student where sex,age in(’男’,20);
- 数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求查询所有男同学信息,下列哪个SQL语句是正确的 A: Select * From Student Where Sex '男' B: Select * From Student Where Sex ='女' C: Select * From Student Where Sex In '男' D: Select * From Student Where Sex ='男'
- 查询年龄不在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
- 对于学生信息表: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
- 查询年龄在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
内容
- 0
数据库中有一张表名称为Student,有列Number,Name,Age,IDCard,Sex。主键为Number。要求查询所有男同学信息,下列哪个SQL语句是正确的?() A: Select* From Student Where Sex=’男’ B: Select* From Student Where Number NotIn(Select Number From Student Where Sex<>=’男’) C: Select* From Student Where NumberIn(Select Numbe rFrom Student Where Sex=’男’) D: Select* From Student Where Sex<>’男&rsquo
- 1
数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求写SQL语句查询出表中年龄介于20和30岁之间的数据,下列哪个SQL语句是正确的?() A: Select*FromStudentWhereAge>=20ANDAge>=30 B: Select*FromStudentWhereAge>=20ANDAge<=30 C: Select*FromStudentWhereAgeBETWENN20AND30 D: Select*FromStudentWhereAge>=20&&Age>=30"
- 2
学生表student中,将年龄小于30岁的记录删除,下面的语句正确的是( )。 A: DELETE FROM student FOR age<;30 B: DELETE FROM student WHERE age<;30 C: DELETE TABLE student WHERE age<;30 D: DELETE FROM student HAVING age<;30
- 3
数据库中有一张表名称为Student,有列Number,Name,Age,IDCard,Sex。主键为Number。要求查询所有男同学信息,下列哪个SQL语句是正确的?() A: ASelect* From Student Where Sex=’男’ B: BSelect* From Student Where Number NotIn(Select Number From Student Where Sex<>=’男’) C: CSelect* From Student Where NumberIn(Select Numbe rFrom Student Where Sex=’男’) D: DSelect* From Student Where Sex<>’男’
- 4
有学生信息表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