要求出学生中平均成绩最高的人的学号、姓名和平均分,下列语句中正确的是______。
A.SELECT TOP 1 学号,姓名,平均分;
FROM STUDENT,SKB.DBF ORDER BY平均分
B.SELECT TOP 1 STUDENT.学号,STUDENT.姓名,AVG(SKB.成绩)AS平均分;
FROM STUDENT INNER JOIN SKB.DBF;
WHERE STUDENT.学号=SKB.学号;
GROUP BY STUDENT.学号;
ORDER BY 3 DESC
C.SELECT TOP 1 STUDENT.学号,STUDENT.姓名,AVG(SKB.成绩)AS平均分;
FROM STUDENT INNER JOIN SKB.DBF;
ON STUDENT.学号=SKB.学号;
GROUP BY STUDENT.学号;
ORDER BY 3 DESC
D.SELECT TOP 1 PERCENT STUDENT.学号;
STUDENT.姓名,AVG(SKB.成绩)AS平均分;
FROM STUDENT INNER JOIN SKB.DBF;
ON STUDENT.学号=SKB.学号;
GROUP BY STUDENT.学号;
ORDER BY 3 DESC