与WHERE AGE BETWEEN 18 AND 23完全等价的是( )。A.WHERE AGE>18AND AGEB.WHERE AGE>=18AND AGEC.WHERE AGE>18AND AGED.WHERE AGE>=18AND AGE
与WHERE AGE BETWEEN 18 AND 23完全等价的是( )。
A.WHERE AGE>18AND AGE
B.WHERE AGE>=18AND AGE
C.WHERE AGE>18AND AGE
D.WHERE AGE>=18AND AGE
相关考题：
使用SQL语句将学生表S中年龄（AGE）大于30岁的记录删除，正确的命令是（ ）。A．DELETE FOR AGE30B．DELETE FROM S WHERE AGE30C．DELETE S FOR AGE30D．DELETE S WHERE AGE30
●在SQL中，下列涉及空值的操作，不正确的是 (23) 。(23) A．AGE IS NULLB．AGE IS NOT NULLC．AGE=NULLD．NOT(AGE IS NULL)(23) A．AGE IS NULLB．AGE IS NOT NULLC．AGE=NULLD．NOT(AGE IS NULL)
使用SQL语句将学生表S中年龄(AGE）大于30岁的记录删除，正确的命令是A）DELETE FOR AGE30 B）DELETE FROM S WHERE AGE30C）DELETE S FOR AGE30 D）DELETE S WHERE AGE30
检索所有比“王华”年龄大的学生的姓名、年龄和性别，正确的SELECT语句是______。A．SELECT SN,AGE,SEX FROM S SHERE AGE＞(SELECT AGE FROM S WHERE SN='王华')B．SELECT SN,AGE,SEX FROM S WHERE SN='王华'C．SELECT SN,ACE,SEX FROM S WHERE AGE＞(SELECT ACE WHERE SN='王华')D．SELECT SN,ACE,SEX FROM S WHERE ACE＞王华 AGE
对于学生信息表：student(sno，sname，sex，age，dept)，能够得到年龄在20岁到22岁之间的学生的姓名和学号的语句是A．SELECT * FROM student WHERE age BETWEEN 20 AND 22B．SELECT sname，sno FROM student WHERE age BETWEEN 20 AND 22C．SELECT sname，sno FROM student WHERE age＞=20D．SELECT sname，sno FROM student WHERE age＜=22
对于学生信息表S(SNUMBER，SNAME，SEX，AGE，DEPT)(STUDENT由学号SN0，姓名SNAME，性别SEX，年龄AGE，所在系DEPT5个属性组成，其中SNUMBER为主码)，求年龄20～23岁之间的学生姓名和年龄，正确的语句是（ ）。A) SELECT SNAME, AGE FROM S WHERE AGE20 OR AGE23B) SELECT SNAME, AGE FROM S WHERE AGE BETWEEN 20 AND 23C) SELECT * FROM S WHERE AGE BETWEEN 20 AND 23D) 以上均不正确
根据SQL标准，要查询表student中平均年龄age小于21的所在系dept及其平均年龄值，下面哪条语句适用?()A select dept,avg(age) from student where avg(age)B select dept,avg(age) from student group by dept having avg(age)C select dept,avg(age) from student having avg(age)D select dept,avg(age) from student group by dept where avg(age)
根据SQL标准，要修改表student中所有学生的年龄age，使之在原值基础上减一，下面哪个语句适用?()A update student set age = 1B update student set age = age - 1C update age = age -1 from studentD update from student where age = age -1
根据SQL标准，下面哪句语句能够找出年龄最小的同学?其中age为学生表student中的年龄字段，sno为学生的学号。()A select max(age) from studentB select sno from student where age = max(age)C select sno from student having age = max(age)D select sno from student a where a.age
根据SQL标准，下面哪条语句与select min(age) from student等效?()A select age from student where age >= min(age)B select distinct age from student where age >= all min(age)C select distinct a.age from student a where a.ageD select distinct a.age from student a where a.age
S(S#,SN,SEX,AGE,DEPT) C(C#,CN) SC(S#,C#,GRADE)其中：S#为学号，SN为姓名，SEX为性别，AGE为年龄，DEPT为系别，C#为课程号， CN为课程名，GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是______。A．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE FROM S WHERE SN＝'王华')B．SELECT SN, AGE, SEX FROM S WHERE SN='王华'C．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE WHERE SN＝'王华')D．SELECT SN,AGE,SEX FROM S WHERE AGE＞王华AGE
S(S,SN,SEX,AGE,DEPT)C(C,CN)SC(S,C,GRADE)其中:S为学号,SN为姓名,SEX为性别,AGE为年龄,DEP S(S#,SN,SEX,AGE,DEPT) C(C#,CＮ) SC(S#,C#,GRADＥ) 其中：S#为学号，SN为姓名，SEX为性别，AGE为年龄，DEPT为系别，C#为课程号， CN为课程名，GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别。 正确的SELECT语句是______。A．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE FROM S WHERE SN＝‘王华’)B．SELECT SN,AGE,SEX FROM S WHERE SN＝‘王华’C．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE WHERE SN＝‘王华’)D．SELECT SN,AGE,SEX FROM S WHERE AGE＞王华 AGE
对于学生信息表STUDENT（SNO， SNAME，SEX，AGE，DEPT)（STUDENT由学号SNO、姓名SNAME、性别SEX、年龄AGE、所在系DEPT 5个属性组成，其中SNO为主码），求年龄20～23岁之间的学生姓名和年龄，正确的语句是（ ）。A．SELECT SNAME，AGE FROM STUDENT WHERE AGE20 AND AGE23B． SELECT*FROM STUDENT WHERE AGE BETWEEN 20 AND 23C．SELECT SNAME，AGE FROM STUDENT WHERE AGE BETWEEN 20 AND 23D．以上均不正确
若要求查找“年龄大于18岁学生的学生号和姓名”，正确的SQL语句是( )。A．SELECT S#，SNAME FROM S WHERE AGE18B．SELECT S#，SNAME FROM S WHERE AGE=18C．SELECT S#，SNAME FROM S WHERE AGE'18'D．SELECT S#，SNAME FROM S WHERE AGE='18'
学生关系模式 S（ S＃，Sname，Sex，Age），S的属性分别表示学生的学号、姓名、性别、年龄。要在表S中删除一个属性“年龄”，可选用的SQL语句是（ ）。A. DELETE Age from S B. ALTER TABLE S DROP AgeC. UPDATE S Age D. ALTER TABLE S ‘Age’
检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是______。A．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE FROM S WHERE SN='王华')B．SELECT SN,AGE,SEX FROM S WHERE SN='王华'C．SELECT SN,AGE, SEX FROM S WHERE AGE＞(SELECT AGE WHERE SN='王华')D．SELECT SN,AGE,SEX FROM S WHERE AGE＞王华 AGE
对于学生信息表（XSB），包含字段：学号（SNO），姓名（SNAME），性别（SEX），年龄（AGE），所在系（DEPT），其中SNO为主码，检索年龄在20~30之间的学生姓名和年龄，正确的语句是（）A、select sname，age from xsb where age20and age23B、select*from xsb where age between20 and 23C、select sname，age from xsb where agebetween20 and 23
数据库中有一张表名称为Student，有列Name，Age，IDCard，Sex。要求写SQL语句查询出表中年龄介于20和30岁之间的数据，下列哪个SQL语句是正确的？（）A、Select* From Student Where Age=20 ANDAge=30B、Select* From Student Where Age=20 ANDAge=30C、Select* From Student Where Age BET WENN 20AND30D、Select* From Student Where Age=20Age=30"
SQL的查询语句的where子句中，对空值的操作，不正确的是（）A、where AGE IS NULLB、where AGE IS NOT NULLC、where AGE = NULLD、where NOT (AGE IS NULL)
与WHERE AGE BETWEEN 18 AND 23完全等价的是（）A、WHERE AGE＞18AND AGE＜23B、WHERE AGE＞＝18AND AGE＜23C、WHERE AGE＞18AND AGE＜＝23D、WHERE AGE＞＝18AND AGE＜＝23
单选题SQL的查询语句的where子句中，对空值的操作，不正确的是（）Awhere AGE IS NULLBwhere AGE IS NOT NULLCwhere AGE = NULLDwhere NOT (AGE IS NULL)
单选题与WHERE AGE BETWEEN 18 AND 23完全等价的是（）AWHERE AGE＞18AND AGE＜23BWHERE AGE＞＝18AND AGE＜23CWHERE AGE＞18AND AGE＜＝23DWHERE AGE＞＝18AND AGE＜＝23
在数据库查询语句中，“age between 30 and 40”等同于（ ） (1.0分) [单选.] A. age>=30 or age=30 and age30 and age30 or age<40