更多“数据库SQL语言中,AGE IN(15,35)短语的正确含义是(14)。A.AGE=15AND AGE=35B.AGE=15 OR AGE=35C.AG ”相关问题
  • 第1题:

    根据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


    参考答案C

  • 第2题:

    如果要在SPSS数据中选择出年龄(age)在18-60岁的所有个案,则下列哪个条件表达式是正确的?【 】

    A.age>=18 & age<=60

    B.age>=18 | age<=60

    C.18<= age <=60

    D.age>=18 & <=60


    age>=18 & age<=60

  • 第3题:

    16、要求男生(SEX=‘M’)年龄(AGE)在15到60之间,女生(SEX=‘F’)年龄在15到55之间,则正确的约束检查语句是()。

    A.CHECK(age>=15 AND ((SEX=’M’ AND AGE <=60) AND (SEX=’F’ AND AGE<=55)))

    B.CHECK(age>=15 AND ((SEX=’M’ AND AGE <=60) OR (SEX=’F’ AND AGE<=55)))

    C.CHECK(age>=15 OR ((SEX=’M’ AND AGE <=60) OR (SEX=’F’ AND AGE<=55)))

    D.CHECK(age>=15 OR ((SEX=’M’ AND AGE <=60) AND (SEX=’F’ AND AGE<=55)))


    CHECK(age>=15 AND ((SEX=’M’ AND AGE <=60) OR (SEX=’F’ AND AGE<=55)))

  • 第4题:

    要求男生(SEX=‘M’)年龄(AGE)在15到60之间,女生(SEX=‘F’)年龄在15到55之间,则正确的约束检查语句是()。

    A.CHECK(AGE>=15 AND ((SEX=’M’ AND AGE <=60) AND (SEX=’F’ AND AGE<=55)))

    B.CHECK(AGE>=15 AND ((SEX=’M’ AND AGE <=60) OR (SEX=’F’ AND AGE<=55)))

    C.CHECK(AGE>=15 OR ((SEX=’M’ AND AGE <=60) OR (SEX=’F’ AND AGE<=55)))

    D.CHECK(AGE>=15 OR ((SEX=’M’ AND AGE <=60) AND (SEX=’F’ AND AGE<=55)))


    CHECK(age>=15 AND ((SEX=’M’ AND AGE <=60) OR (SEX=’F’ AND AGE<=55)))

  • 第5题:

    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


    A