SQL中,“AGE IN(15,35)”短语的正确含义是( )。
A.AGE=15 AND AGE=35
B.AGE=15 OR.AGE=35
C.AGE<=35 AND AGE>=15
D.AGE<35 AND AGE>15
第1题:
A.age=0
B.age=null
C.age=
D.程序编译错误
第2题:
如果学生表STUDENT是使用下面的SQL语句创建的CREATE TABLE STUDENT (SNO C (4) PRIMARY KEY NOT NULL , ;SN C (8) , ;SEX C (2) , ;AGE N (2) CHECK (AGE>15 AND AGE<30 ))下面的SQL语句中可以正确执行的是A)INSERT INTO STUDENT(SNO,SEX,AGE)VALUES("S9","男",17)B)INSERT INTO STUDENT(SN,SEX,AGE)VALUES("李安琦","男",20)C)INSERT INTO STUDENT(SEX,AGE)VALUES("男",20)D)INSERT INTO STUDENT(SNO,SN) VALUES("S9","安琦",16)
第3题:
16、下面哪一个表达式能正确表示逻辑关系:"age≥18 或age≤60"?
A.age>=18 or age<=60
B.age>=18 | age<=60
C.age>=18 && age<=60
D.age>=18 || age<=60
第4题:
根据SQL标准,要查询表student中所有年龄age小于所有学生的平均年龄的记录,下面哪条语句适用?()
A select * from student where age< avg(age)
B select * from student having age< avg(age)
C select * from student a where a.age< (select avg(b.age) from student b)
D select * from student a where (select avg(b.age) from student b ) >= a.age
第5题:
如果要在SPSS数据中选择出年龄(age)在18-60岁的所有个案,则下列哪个条件表达式是正确的?【 】
A.age>=18 & age<=60
B.age>=18 | age<=60
C.18<= age <=60
D.age>=18 & <=60