若想要查询表 student 班级为 1 班"且成绩排名前五名的学 生信息，以下语句能实现的是？
A.select*from student where class_id=1 order by score desc limit 5; B.select*from student where class_id=1 order by score desc offset 5; C.select*from student where class_id=1 order by score limit 5 D.select*from student where class_id=1 group by score limit 5正确答案A
