以下哪项不属于SQL中常用的分组函数?()
A.AVG(num)
B.Sum (num)
C.Count(*)
D.Mid (num)
A.AVG(num)
B.Sum (num)
C.Count(*)
D.Mid (num)
第4题
A.指定要由RIGHT提取的字符的数量Num—chars
B.包含要提取字符的文本字符串Text
C.区域参数range
D.确定哪些单元格将被计算在内的条件参数Criteria
第6题
A.SELECT 性别,COUNT(*) AS 人数 FROM 职工WHERE 工资<800 ORDER BY 性别
B.SELECT 性别,COUNT(*) AS 人数 FROM 职工WHERE 工资<800 GROUP BY 性别
C.SELECT 性别,SUM(*) AS 人数 FROM 职工WHERE 工资<800 GROUP BY 性别
D.SELECT 性别,AVG(*) AS 人数 FROM 职工
第8题
A.“=SUM(A2:A8)”
B.“=SUM(A2,A8)”
C.“=avg(A2:A8)”
D.“=avg(A2,A8)”
第11题
A.select student_id,student_name,sum(score) from student where score<60 order by score;
B.select distinct student_id,avg(score) from student where score<60 order by avg(score);
C.select student_id,student_name,avg(score) av from student where score<60 group by student_id order by av asc;
D.select student_id,student_name,avg(score) av from student group by student_id where score<60 order by av asc;