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