MySQL中,按课程号升序,按成绩降序,对选课信息进行排序,正确的SQL语句是()。
Aselect * from sc order by cno, grade
Bselect * from sc order by cno, grade desc
Cselect * from sc order by cno asc, grade desc
Dselect * from sc order by cno asc desc, grade asc
Aselect * from sc order by cno, grade
Bselect * from sc order by cno, grade desc
Cselect * from sc order by cno asc, grade desc
Dselect * from sc order by cno asc desc, grade asc