在SQL语言中,用于对查询结果计数的函数是()。
A. SUM
B. AVG
C. MIN
D. COUNT
A.COUNT(借阅.借书证号) GROUP BY 单位
B.SUM(借阅.借书证号) GROUP BY 单位
C.COUNT(借阅.借书证号) ORDER BY 单位
D.COUNT(借阅.借书证号) HAVING 单位
A.Select学号,Count(学号)from借阅
B.Select学号,Count(学号)from借阅GroupBy学号
C.Select学号,Sum(学号)from借阅
D.Select学号,Sum(学号)from借阅0rderBy学号
A.MIN(单价) AVGAGE(单价) COUNT(*) GROUP BY
B.MAX(单价) AVG(单价) COUNT(*) ORDER BY
C.MAX(单价) AVG(单价) SUM(*) ORDER BY
D.MAX(单价) AVG(单价) COUNT(*) GROUP BY
A.SELECT歌手号,(COUNT(分数)-MAX(分数)-MIN(分数)/SUM(*)-2)最后得分; FROM评分INTO DBF TEMP GROUP BY歌手号ORDER BY最后得分DESC
B.SELECT歌手号,(COUNT(分数)-MAX(分数)-MIN(分数)/(SUM(*)-2)最后得分; FROM评分INTO DBF TEMP GROUP BY评委号ORDER BY最后得分DESC
C.SELECT歌手号,(SUM(分数)-MAX(分数)-MIN(分数)/COUNT(*)-2)最后得分; FROM评分INTO DBF TEMP GROUP BY评委号ORDER BY最后得分DESC
D.SELECT歌手号,(SUM(分数)-MAX(分数)-MIN(分数)/COUNT(*)-2)最后得分; FROM评分INTO DBF TEMP GROUP BY歌手号ORDER BY最后得分DESC
检索最少有5名职工的每个部门的职工基本工资的总额()。
A.SELECT 部门号,COUNT(*),SUM(基本工资) FROM 职工; HAVING COUNT(*)>=5
B.SELECT 部门号,COUNT(*),SUM(基本工资) FROM 职工; GROUP BY 基本工资 HAVING COUNT(*)>=5
C.SELECT 部门号,COUNT(*),SUM(基本工资) FROM 职工; GROUP BY 部门号 HAVING COUNT(*)>=5
D.SELECT 部门号,COUNT(*),SUM(基本工资) FROM 职工; GROUP BY 部门号 WHERE COUNT(*)>=5
A.SELECT部门号,COUNT(*),SUM(基本工资)FROM职工; HAVING COUNT(*)>=5
B.SELECT部门号,COUNT(*),SUM(基本工资)FROM职工; GROUP BY基本工资HAVING COUNT(*)>=5
C.SELECT部门号,COUNT(*),SUM(基本工资)FROM职工; GROUP BY部门号HAVING COUNT(*)>=5
D.SELECT部门号,COUNT(*),SUM(基本工资)FROM职工; GROUP BY部门号WHERE COUNT(*)>=5