登陆题目详情
单选题 返回组中值的平均值,使用( )函数
学科：数据库原理与应用
时间：2024-01-01 10:48:49
相关题目
相关作业
题目1单选题
查询姓张、姓王、姓刘老师的信息的方法是A. SELECT * FROM Teacher WHERE Teachername like '张%' or Teachername like '王%' or Teachername like '刘%'B. SELECT * FROM Teacher WHERE Teachername like '张%' and Teachername like '王%' or Teachername like '刘%'C. SELECT * FROM Teacher WHERE Teachername like '张%' or Teachername like '王%' and Teachername like '刘%'D. SELECT * FROM Teacher WHERE Teachername like '张%' and Teachername like '王%' and Teachername like '刘%'
题目2单选题
如果包含WHERE子句,则只对满足WHERE条件的行进行分组汇总.( )可进一步排除不满足条件的组A. ORDER BYB. WHEREC. GROUP BYD. HAVING
题目3单选题
中华人民共和国于1949年10月1日成立, 使用SQL语句查询当前日期与1949年10月1日相差多少年的方法是A. SELECT DATEDIFF(YEAR,'1949-10-1',GETDATE())B. SELECT DATEDIFF(YEAR,GETDATE(),'1949-10-1')C. SELECT DATEDIFF(MONTH,'1949-10-1',GETDATE())D. SELECT DATEDIFF(DAY,'1949-10-1',GETDATE())
题目4单选题
SQL是以下哪个的缩写A. sql question localB. sql query languageC. structured query languageD. sql quote language
题目5单选题
下列说法不正确的是( )A. 外码和相应的主码可以同名B. 一个表可以有多个外码C. 含外码的表为子表D. 父表和子表是绝对的,不是相对的
题目6单选题
返回组中值的平均值,使用( )函数A. minB. countC. sumD. avg
题目7单选题
从Student表中选取年龄最大的五名男同学的方法是A. SELECT StudentName AS '姓名', YEAR(Birth) AS '年龄' FROM Student WHERE (Sex = '男') ORDER BY '年龄'B. SELECT StudentName AS '姓名', 2021 - YEAR(Birth) AS '年龄' FROM Student WHERE (Sex = '男') ORDER BY '年龄'C. SELECT TOP (5) StudentName AS '姓名', 2021 - YEAR(Birth) AS '年龄' FROM Student WHERE (Sex = '男') ORDER BY '年龄' DESCD. SELECT TOP (5) StudentName AS '姓名', 2021 - YEAR(Birth) AS '年龄' FROM Student WHERE (Sex = '男') ORDER BY '年龄'
题目8单选题
学生的出生日期采用( )数据类型A. DATAB. CHAR(8)C. DATETIMED. DATE
题目9单选题
下列说法不正确的是( )A. 一个表可以有多个候选码B. 一个表可以有多个主码C. 主码的取值必须唯一且非空D. 唯一码可以空值
题目10单选题
以下哪种方法能查询出不住在东软宿舍3栋的老师信息A. SELECT * FROM Teacher WHERE HomeAddr not like '东软宿舍3栋%'B. SELECT * FROM Teacher WHERE HomeAddr != '东软宿舍3栋%'C. SELECT * FROM Teacher WHERE HomeAddr like '东软宿舍3栋'D. SELECT * FROM Teacher WHERE HomeAddr like '东软宿舍3栋%'
下载 题海APP
拍照搜题更快捷
- 海量题库
- 无搜索限制
- 快捷拍照搜题
