單項選擇題現(xiàn)有學(xué)生住處表Student_info,其中包括姓名(stu_name),學(xué)號(stu_id),成績(stu_grade)。我們需要查詢成績?yōu)?0分的學(xué)生姓名,要求結(jié)果按照學(xué)號降序排列。下面查詢語句正確的是()。

A.SELECT stu_name FROM student_info Where stu_grade=80 ORDER BY stu_id ASC;
B.SELECT stu_name FROM student_info WHERE stu_grade=80 ORDER BY stu_id DESC;
C.SELECT stu_id,stu_name FROM student_info WHERE stu_grade=80 ORDER BY stu_name ASC;
D.SELECT stu_name FROM student_info WHERE stu_grade LIKE 80 ORDER BY stu_id DESC;


您可能感興趣的試卷