注意:此页面搜索的是所有试题
查询每门课程的最高分,要求得到的信息包括课程名称和分数,正确的命令是(B )
A. SELECT 课程名称,SUM(分数)AS分数
FROM curriculum, grade
WHERE curriculum. 课程编号= grade.课程编号
GROUP BY课程名称
B. SELECT 课程名称,MAX(分数)分数
FROM curriculum, grade
WHERE curriculum. 课程编号= grade.课程编号
GROUP BY课程名称
C. SELECT 课程名称,SUM(分数)分数
FROM curriculum, grade
WHERE curriculum. 课程编号= grade.课程编号
GROUP BY curriculum.课程名称
D. SELECT 课程名称,MAX(分数)AS分数
FROM curriculum, grade
WHERE curriculum. 课程编号= grade.课程编号
GROUP BY curriculum.课程名称

参考答案