首页试题列表> 试题详细
单选题
有关系模型 Students(学号,姓名,性别,出生年月),要统计学生的人数和平均年龄应使用的语句是
A.SELECT COUNT() AS 人数,AVG(YEAR(出生年月)) AS 平均年龄 FROM Students;
B.SELECT COUNT(*) AS 人数,AVG(YEAR(出生年月)) AS 平均年龄 FROM Students;
C.SELECT COUNT(*) AS 人数,AVG(Year(Date())-Year(出生年月)) AS 平均年龄 FROM Students;
D.SELECT COUNT() AS 人数,AVG(Year(Date())-Year(出生年月)) AS 平均年龄 FROM Students;

题目知识点:
查看答案
暂无